Have you seen this bug? --> labels = empty

[Bruce Hartman]

I am doing this search:

assignee = currentUser() AND labels not in (XXX, YYY, ZZZ) ORDER BY priority DESC, updated DESC

and I get zero results....

yet if I do this..

assignee = currentUser() ORDER BY priority DESC, updated DESC

I get results, including tickets with Labels = None

[Nic Brough -Adaptavist-]

I can't see a "bug" there, just the (unintuitive for humans, but actually useful) quirk that if you want to see things that do not have a label set at all, you need to ask for it.

Try:

assignee = currentUser() AND (labels not in (XXX, YYY, ZZZ) or labels is empty) ORDER BY priority DESC, updated DESC