JQL Query Quirk involving "not in" and an empty target field

Peter Hochstrasser

Hi all

 

I found a quirk in JQL when selecting - among other things - based on the labels of a ticket:

... AND Labels not in (CR) ...

did not select those tickets with an empty labels field

 

... AND (Labels not in (CR) OR Labels is EMPTY) ...

selects the tickets with empty labels, too.

 

Is this a feature or a bug?

 

TIA

Peter

P.S: the complete query:

project = "<project>" AND status not in (closed) AND type not in (Epic, "Technical task") AND summary !~ "ALL STORIES" AND summary !~ "NEW Tickets" AND summary !~ "Tickets on hold" AND (Labels not in (CR) OR Labels is EMPTY) ORDER BY status DESC

Udo Brand

Personally I don't think it is a bug.

But it was reported : https://jira.atlassian.com/browse/JRA-24511 and closed with won't fix (see the duplicated issue)