Which JQL statement to choose ?

MV August 31, 2020

Hi guys,

the following situation, I have different items in place with different labels like this

Item 1 :  Label A, Label B, Label C
Item 2 :  Label A
Item 3 : Label D
Item 4 : Label B, Label C, Label H
Item 5 : Label D, Label F
Item 6 : Label G

I want to create a JQL which helps me identifying alle items which don't have a Label A or Label B or Label C

My expected Result would be : Item 3, Item 5, Item 7

I try the following:

Filter = "MyFilter" and ( labels != "Label A" OR labels != "Label B" or labels != "Label C") 
or
Filter = "MyFilter" and ( labels not in ("Label A","Label B","Label C")

But both filters also results in items that have one of the three labels in place 

Hope you can help me 

Thanks

 

Greetings 

1 answer

0 votes
Amanda Kirk
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 31, 2020

Hello,

Have you triedL

Filter = "MyFilter" and ( labels != "Label A" AND labels != "Label B" AND labels != "Label C") 

This would mean that the issue does not have A AND does not have B AND does not have C

Suggest an answer

Log in or Sign up to answer