Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

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 !

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

253 views 1 5
Read article

Community Events

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

Events near you