Labels Filter "NOT IN" is not working.

[Yasin Arafat]

I have a filter that working fine:

assignee in (currentUser()) AND status in ("In Code Review", "In Development", "In Progress", "In progress", Open) ORDER BY priority DESC, created DESC

But when I add: AND labels not in (qa_effort_only). It return nothing (no ticket found).

[Yasin Arafat · Accepted solution]

We should always add labels is empty. Like:

AND (labels not in (qa_effort_only) or labels is empty)

[Frederik Vantroys]

Hi @Yasin Arafat ,

Since you have only one condition you could try with

and labels != "qa_effort_only"

Also ... important to think what you want to do with items that have no labels. Maybe you have to add :

AND (labels not in (qa_effort_only) or labels is empty)

[Yasin Arafat]

and labels != "qa_effort_only"     not working

but adding labels is empty works.