Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,464,351
Community Members
 
Community Events
176
Community Groups

JQL excluding label while keeping empty label issues in filter query

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? 

 

2 answers

1 accepted

6 votes
Answer accepted

(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

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...

Like Maridali Gonzalez likes this

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

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 !

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

Like # people like this

Thanks! I almost went mad.

Like Pamela Keogh likes this

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'

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

Like # people like this

This worked for me, thank you!

Like Livia likes this

Thanks Livia. This has helped me too :)

Like Livia likes this

This was just what I needed too! thank you! 

Like Livia likes this

Thanks Livia too :)

Like Livia likes this

It works for me too. Thank you!

Like Livia likes this

this worked for me as well! Thank you!

Like Livia likes this

Thank you! This worked well. Much appreciated.

Like Livia likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events