nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I filter to exclude a label?

Alex Bea1

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?

Accepted answers

Dave

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

All comments

Dave

Hi Alex,

Thanks,

-dave

Alex Bea1

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

Daniel Luevano_ezwo3t

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?

Ollie Blacklock

I think this works:

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

Felix Zimmermann

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

Seif Eldin Serag

You're my hero. Thank you

Ryan Bullock_1cnnlc

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

Roger_mko8im

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, " then none of the above stories appears as result.

Prashant Sultania

Hello @Roger

You can use following JQL to filter it

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

This will give you the expected result.

Denis Howe

Ollie's solution is shorter and works for me.

Denis Howe

You might think that

labels not in (...)

means "labels does not include any of ...", which would obviously be true for tickets with no labels.

But actually it seems to be interpreted as "labels includes some items not in ...".

I guess it's consistent with "x not in (...)" where "x" is a simple value rather than a set, where it means "x has some value other than ..." but it's very confusing.