JQL labels not in (LabelName)

[Jeff Santos]

Hi,

Im trying to save a filter with a JQL of all issues thah DO NOT contain a certain label.

However, I realized it simply doesn't work.

when I search :

labels == Recorrente  

or 

labels in (Recorrente) 

It works fine.

But if I try to do the opposite, it doesn't work:

labels != Recorrente 

labels not in (Recorrente)

Any ideas about how can I workaround it?

Thanks! 

[Hana Kučerová · Accepted solution]

Hi @Jeff Santos ,

it seems to me, that the problem is, that you have forgotten to add the issues, which have no labels.

Please, try this:

labels is EMPTY OR labels not in (Recorrente)

[Jeff Santos]

HI @Hana Kučerová ,

It worked fine. 

I really thought that using != would make it necessary to specify that I wanted issues with empty labels.

Thank you for the help!

[CGIschabotbeaulieu]

Works - Thanks :)

[Andy Finley]

This isn't working for me and I have no idea why.  I've found no less than three different versions of this question and all of them provide the same answer.  I need to find issues that either have Labels empty or have a Label that is not THU.  The logic provided here, and elsewhere isn't working:

project = "Physicians Organization Service Desk" AND issuetype = Change AND status not in (Closed, Resolved) AND assignee in membersOf("Epic PB Application") AND status = "Waiting for approval" AND (labels is EMPTY or labels not in (THU))

All I get in response are issues where Labels is empty.

[Hana Kučerová]

Hi @Andy Finley ,

I don't see anything wrong with your JQL. As your JQL is complex, I would recommend you start debugging like this:

1. try JQL: 
   labels is EMPTY or labels not in (THU)
   and see, which issues you get
2. if these issues are correct, then add another paramater to JQL:
   project = "Physicians Organization Service Desk" AND (labels is EMPTY or labels not in (THU))
   and so on...

[Dusan Sancanin]

The results show all tasks, from all the previous sprints although I define the sprint name
"AND sprint = sprint ID"

Any idea why?

[Matt Bradley]

Hey there @Andy Finley I had the same issue as you and got this to work by using additional brackets. To essentially run the first part of the query first before the label aspects. 

So for me (labels is EMPTY OR labels not in (cookies-blocker, cookies-mvp)) And filter=99501

I'm also using a saved query for ease. 

Thanks 

[rstimson]

It works!

To me, it would more sense if labels not in (x) returned the opposite of labels in (x). I don't think specifying labels = EMPTY should be necessary in this case.

[Keith Robertson]

Instead of

labels != Recurrent

labels not in (Recurrent, Irreproducible)

use

# Select ticket if missing the named label.
NOT (labels = Recurrent)

# Select ticket if missing ANY of the named labels.
NOT (labels = Recurrent AND labels = Irreproducible)

# Select ticket only if missing ALL of the named labels.
NOT (labels in (Recurrent, Irreproducible))

These avoid having to check whether labels IS EMPTY.