JQL condition does not include records where X is empty

The JQL statement below returns what I expected.

Project = "XYZ" AND Type = Bug AND Status != Done AND Creator = currentUser() ORDER BY createdDate DESC

However I want to filter out any records with the Label = Crash.

So I added an additional condition to the statement.

Project = "XYZ" AND Type = Bug AND Status != Done AND Labels != Crash AND Creator = currentUser() ORDER BY createdDate DESC

The problem is that the query does not return records where Labels is empty.

Is this expected? What can I add to the statement that would include those records?

1 answer

Community moderators have prevented the ability to post new answers.

2 votes

Answer accepted

Yes, adding that will limit the result set to only issues containing one or more labels. To also include issues without labels, you can do this:

Project = "XYZ" AND Type = Bug AND Status != Done AND (Labels is empty or Labels != Crash) AND Creator = currentUser() ORDER BY createdDate DESC

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Exactly what I was looking for. Thanks so much.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.