I created a filter for open issues, and need it to exclude tickets that have Done as status. I can't seem to be able to do that.
I copied the syntax (statusCategory != done) from a colleague's filter where they are excluded. I also tried using a different field (status != done) and still, I keep seeing Done tickets in the list.
What am I missing? Is the Status field in my project simply mapped to something different in JQL, and if so, how would I go about finding out what it is?
In case it helps, this is the full filter syntax (everything else I'm asking it to do, it's doing correctly):
component in ("Instant Awards & eCards", "Nominations & File Uploads", "Connect App") AND statusCategory != done AND labels = rnr-incident OR labels = rnr-request OR labels = rnr-improvement AND project = "Reward Gateway Development" ORDER BY priority DESC, status DESC
Put some parentheses around the OR clauses
component in ("Instant Awards & eCards", "Nominations & File Uploads", "Connect App") AND statusCategory != done AND (labels = rnr-incident OR labels = rnr-request OR labels = rnr-improvement) AND project = "Reward Gateway Development" ORDER BY priority DESC, status DESC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Federica,
you are using Jira Cloud? What statuses does your workflow have? Is the Done Status colored green?
Another option you might want to try is using: resolution is empty
Regards,
Kai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Kai!
Yes, the Done Status is indeed coloured green.
Someone else suggested I format the query differently and that seems to have done the trick. I will keep "resolution is empty" in mind, too, in case it comes in useful in future.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.