Cannot make a filter working

[Fabien Frances]

Hello,

Here is my filter:

project = "XWZ" AND labels not in ("[OXO]-Onboarding")

and it shows nothing and no error

if I change the filter to be 

project = "XWZ" AND labels in ("[OXO]-Onboarding")

Then it shows every issue with this labels

Thank in advance for your help

Kind regards

[Sreenivasaraju P · Accepted solution]

Hi @Fabien Frances ,

Can you please check do you have tickets with any other label. 

project = "XWZ" AND labels not in ("[OXO]-Onboarding") - this query will list the tickets with label only (other than "[OXO]-Onboarding"). It won't list the ticket with no label.

[Fabien Frances]

Ok got you, if there is no label it won't show.

Then if I put 

project = "XWZ" AND labels != "[OXO]-Onboarding"

Still not showing.

What I am looking is to show all issues that have not this label basically.

Thanks

[Sreenivasaraju P]

Please try with below query

project = XWZ AND (labels != "[OXO]-Onboarding" or labels is EMPTY )

[Fabien Frances]

That works!!

Thanks for your help, greatly appreciated!