JQL excluding label while keeping empty label issues in filter query

[Nathan Charpentier]

Hi, 

I'm trying to exclude a label and found a solution, except that it excludes empty labels. 

Does anyone know of a way to exclude one label from a query while keeping all other issues not in that label or empty? 

[Ilya Turov · Accepted solution]

(labels != yourLabel or labels is EMPTY)

consider just first part of this JQL as looking for issues with any label besides this specific, that's strange logic, but thats the only one I can find to explain this bahaviour

[Nathan Charpentier]

Hi Ilya, 

Thank you for your answer. 

I actually tried this option already and my problem is that most of my issues have an empty labels. I'm trying to exclude one label but include all issues with an empty label field or other labels. 

With this option all issues with an empty label are excluded by default...

[Ilya Turov]

you either exclude issues with empty labels, or include them

there's no middle ground

you can limit amount of issues by applying additional constraints, like specifying project, or issuetype, or something else

[Nathan Charpentier]

Ok, I guessed it wouldn't be possible to find a middle ground. 
I'll try a workout by adding a label to all my issues with empty label and that should do the trick. 

Thanks !

[Pamela Keogh]

So it seems that anything after OR in a filter resets the filter so you'll just need to add the Project name in again. For example. That's done the trick for me! 

labels != YourLabelName OR Project = ProjectName AND Labels is EMPTY

[Roeland van Houten]

Thanks! I almost went mad.

[Juuso Ikonen]

@Pamela Keogh You can work around this by putting the labels part into parentheses. For instance:

Project = YourProject AND (labels != YourLabel OR labels is EMPTY)

This way the information before the OR is remembered.

[Pamela Keogh]

Nice! thanks @Juuso Ikonen !

[Livia]

I managed to work out a solution to exclude one (or more labels) but include all issues with an empty label or other label - you can put them in brackets:

e.g. project = TT AND (labels is EMPTY OR labels not in (label-one, label-two))

This shows all tickets except for anything labelled as 'label-one' or 'label-two'

[Anna Poppe]

Thanks so much! This is just was I was looking for :)

[Richard Herrada]

This worked for me, thank you!

[Amna Imtiaz]

Thanks Livia. This has helped me too :)

[Kat Murphy]

This was just what I needed too! thank you! 

[Celine BEUCHET]

Thanks Livia too :)

[Roxanne Mae Sumaya]

It works for me too. Thank you!

[Meghann Wright]

this worked for me as well! Thank you!

[Alexei Chechin]

Thank you! This worked well. Much appreciated.