Labels Filter "NOT IN" is not working.

Question

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.

akanksha jaiswal_z9yl2j · Answer

Thank you , that gives right results

Joseph Chung Yin · Answer

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

Nic Brough -Adaptavist- · Answer

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)