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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

How do I filter to exclude a label?

I'm having trouble using the JQL syntax to exclude a single label from a Greenhopper board. I get errors when trying to use "labels !~ theming" and "labels != theming" returns no results (because of most returning NULL for labels, I think). "Theming" is the label I'm excluding in this example, and in real life.

What is the syntax to exclude only a single label from a board using filters?

3 answers

1 accepted

37 votes
Answer accepted
Dave Atlassian Team Dec 17, 2012

Hi Alex,

I just gave this a try with project=project AND (labels != 'test' OR labels is EMPTY) and was able to pull up all issues in my project except those with the test label. Give this a try and let us know how it goes.

Thanks,

-dave

Looks like that did it! I'd tried NULL rather than Empty. Thank, Dave.

Like Seif Eldin Serag likes this

From the future I would like to thank you for your awesome solution. Thanks, Dave!

Like # people like this

You're my hero. Thank you

Like Eric Willig likes this

Worked!  Thanks.

Like Eric Willig likes this

Thanks for posting answer David, exactly what I was looking for!

Like Eric Willig likes this

Thanks for the tips !

Like Eric Willig likes this
Like Eric Willig likes this

Really Helpful. I was exactly looking for this.

Thank you!! Really helpful!

But wouldnt this exclude labels that are Empty. What if I just wanted to exclude the issues having that particular label

Perfect!  Thanks!

if you want to do this with more than one label, you need to add the is EMPTY value for every label?

I have something like this:

project = "[PROJECT]" AND status in (Open, "In Progress", Reopened) AND (labels!= postponed OR labels is EMPTY) AND (labels !=testing_functionality_ignore OR labels is EMPTY)

but if you want to exclude 40 labels?

I think this works:

project = "[PROJECT]" AND status in (Open, "In Progress", Reopened) AND (labels not in (label1,label2,...,label40) OR labels is EMPTY)

Like # people like this

Adding the first solution twice worked for me. So if my two labels I want to exclude are project and systemupgrade:

...AND (labels != project OR labels is EMPTY) AND (labels != systemupgrade OR labels is EMPTY)...

Like Seif Eldin Serag likes this

I have following problem with labels, because a story can have multiple lables and I would like to filter the following

Story 1 - Label A, B, C, D

Story 2 - Label A, D

Story 3 - Label A, B, E

=> select alle story which NOT have label A or B -> expected result Story 1 and 2

if i enter "Label not in (A, B)" then none of the above stories appears as result.

Hello @Roger Greuter 

 

You can use following JQL to filter it

project = "Project name" AND issuetype = Story AND (labels != label A OR labels != label B)

This will give you the expected result.

Suggest an answer

Log in or Sign up to answer
TAGS

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