Why is this JQL filtering out issues without a label?

Esther Strom_ ACP-JA

I have the following filter:

 

(assignee = currentUser() OR Developer = currentUser()) AND assignee = currentUser() AND status not in (Closed, Done) AND project not in (Loyalty, JIRA) ORDER BY fixVersion ASC, status ASC, priority DESC

This works correctly. I now want to add a clause to exclude tickets with a certain label, so I did this:

 

(assignee = currentUser() OR Developer = currentUser()) AND assignee = currentUser() AND status not in (Closed, Done) AND project not in (Loyalty, JIRA) AND labels not in (jira-dev-test) ORDER BY fixVersion ASC, status ASC, priority DESC

 

Now it's filtering out issues with that label, but also filtering out all issues without a label. What am I doing wrong? 

Nic Brough -Adaptavist-

It's because most human languages are fuzzy and imprecise, and we translate badly when we're talking to the computers.

You have three possibilities here:

• No labels set
• Label jira-dev-test is present
• Labels are present (like penguin and flibble) but not jira-dev-test

Your clause is precise, but expressed in English, it says "look at the labels and tell me when jira-dev-test is not there".  If the issue has no labels, there's nothing to look at.  So it can't tell you that jira-dev-test is not there.  You need to catch the "no label" fact somehow, and the nice clear way to do it is:

 AND (labels not in (jira-dev-test) or labels is empty)