I have tried various advanced searches and cannot get the syntax right. I want to look for all issues of certain status (for example, open or reopened or inprogress) but exclude any with a certain label (for example OnHold). Tried every kind of NOT but cannot get it to work. HELP please.
The case this doesn't resolve is for issues with any other labels.
In JIRA on demand this query returns the same issues as a query returning only issues with no labels. The inclusion of not in (
) makes no difference.
I have issues logged that have a "DEMO" label. operationally I want to filter these out, prety much as the OP. There wasn't a proper anser above, a couple of fragments so I eventually came up with:
and (labels is empty or (labels is not empty and labels not in (DEMO)))
This means if it's empty, list it. If it has any label, filter out issues that have the DEMO label. Hope that clarifies things.
Unfortunately this doesn't seem to work for me.
the query is slightly more complicated:
project in (WIN) AND issuetype in (Epic, Initiative) AND status not in (Delivered, Closed, Cancelled) AND (labels not in ("Prime-Backlog") OR labels is EMPTY)
I get the same number of issues back with or without the last AND clause and get labels I don't want.
When you say NOT in, it will find issues without that label but in the mentioned statuses. Are you saying you have issues in those states without the label?
May be caused by the problem I report in
Seems to search for A and not B, you must say
A AND NOT B
A NOT B
which the documentation says.
tried this as well without sucess.
I got zero results back even if i have issues from that project without label = xy
I am using JIRA 5.2.1
Any more suggestions?
Thanks for your help This helped me with a query I was trying to get to work.
status in ("current sprint") AND (labels not in ("Tasking") OR labels is EMPTY)
I had same issue. Had difficulties to filter Labels. I am using version 7.5.3
(labels not in (X,Y) or labels is EMPTY ) and status in (Backlog, Analysis).
Adding the "labels is empty" helped.
Problem is correctly identified above by Thomas Tulinksy. Beware that adding "labels is empty" appears to help (i.e. you suddenly see results, hurrrah) but does not show any issue that has a different label (e.g. "Z")
To overcome it, you must use the AND NOT exactly as Thomas described.
Status in (Backlog, Analysis) AND (NOT labels in (X,Y) OR labels is EMPTY) ORDER BY LABELS ASC
Teams break work down in order to help simplify complex tasks. This is often done iteratively, with tasks being broken down into smaller tasks and so on until the work is accurately captured in well-...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events