JQL - Filter to exclude specific labels? 🙏

[Nick]

Hi,

I have the following query and wish to add a filter to exclude 2x specific labels from the view.

Let's call the two labels "label1" and "label2".

So I want the query to return all issues that match the rest of the query, including EMPTY, but EXCLUDING ANY issues assigned either "label1" and "label2"

This is my query so far:

project IN ("Project X") AND type IN (Task,Story) AND status IN ("To Be Refined","In Refine") AND component in ("Launchpad") ORDER BY Rank

Any ideas?

Thanks,

N 

[David Blank · Accepted solution]

HI @Nick !

Could the following work?

labels NOT IN (label1, label2)

Like:

project IN ("Project X") AND type IN (Task,Story) AND status IN ("To Be Refined","In Refine") AND component in ("Launchpad") AND labels NOT IN (label1, label2) ORDER BY Rank

[Nick]

HI @David Blank - Thanks for your suggestion, but unfortunately, no such luck.

Here's my query after adjusting it to consider your suggestion:

project in ("Project1") AND type in (Task, Story) AND status in ("To Be Refined", "In Refine") AND component in (Launchpad) AND labels NOT IN (Label1, Label2) ORDER BY Rank

 The query seems to be successfully excluding "label1" and "label2", however, it is ignoring (i.e. not returning) issues where the label field is empty...

In other words, the query is only returning issues that have labels, where the labels are not "label1" or "label2"..

[David Blank]

Hi @Nick could you try adding: OR labels IS EMPTY?

You will want to put both of your labels filters in parenthesis I think if you do it that way.

Like: 

project in ("Project1") AND type in (Task, Story) AND status in ("To Be Refined", "In Refine") AND component in (Launchpad) AND (labels NOT IN (Label1, Label2) OR labels IS EMPTY) ORDER BY Rank

[Nick]

Nailed it! Thank you so much!!