Labels Filter "NOT IN" is not working.

[Adeel Sarwar]

Hi

I have a filter project = SF AND issuetype = Task AND (labels not in (KDD)).

It is a simple filter where i want to see all issue types tasks where we do not have a label "KDD". If i do "IN KDD" it works fine however "NOT IN" or "!=" does not work. I have tried different iterations reading blogs but nothing is working e.g.

project = SF AND issuetype = Task AND labels not in KDD.

project = SF AND issuetype = Task AND labels != KDD.

etc.

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

My guess is that it is working fine, but you were expecting issues with no label to appear as well.  "Not in" can only work with labels that have a value.

Try 

project = SF AND issuetype = Task AND (labels not in (KDD) or labels is empty)

[akanksha jaiswal]

Thank you , that gives right results

[Joseph Chung Yin]

@Adeel Sarwar -

Welcome to the community.  You just missed the following syntax in your JQL.  Give the following JQL where Label value is enclosed with " " characters.  This will work.

project = SF AND issuetype = Task AND labels not in ("KDO").

project = SF AND issuetype = Task AND labels != "KDD"

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.