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,369,551
Community Members
 
Community Events
168
Community Groups

Which JQL statement to choose ?

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

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
TAGS

Atlassian Community Events