nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL doesn't work correct with "labels is not (...)"

stephan71

Hello,

we have a project DP with some issues labeled with "CR".

If I use the JQL query

project = DP AND type = Requirement AND labels in (CR)

I get the correct result. But if I use the JQL query

project = DP AND type = Requirement AND not labels in (CR)

I get a empty result, which isn't true.

I can't see an error in the log.

Could you help, please?

Kind regards
Stephan

Accepted answers

stephan71

Sorry, you are all right! But I made a mistake, I used "labels not in (CR)" and I get no result.

Nic Brough -Adaptavist-

My guess is that it is working fine, but you are not looking for issues that do not have any label (which is not the same as "has a label which is not X", which is what your search says)

I think you want to search for both cases:

and (labels != CR or labels is empty)

All comments

Mirek

Hi @stephan71

I think the correct format would be

labels not in ("CR")

labels != CR

Jakal Krook

If you run a search query on JIRA and JQL, it returns the search result. One of the fields displayed after the search result is "Labels" which displays all the labels attached to issues. If you search for issues that are created by a particular assignee, then the "Labels" field will contain a list of labels attached to issues created by that particular assignee.

Sachin Dhamale_o1c5zi

@stephan71 ,

Try this one

labels not in (CR)

stephan71

Sorry, you are all right! But I made a mistake, I used "labels not in (CR)" and I get no result.

Sachin Dhamale_o1c5zi

@stephan71

Just try following JQL and see the result

labels not in (CR)

project = DP AND labels not in (CR)

type = Requirement AND labels not in (CR)

And also try to perform the indexing on Project DP and then check again

Might be indexing issue.

Nic Brough -Adaptavist-

My guess is that it is working fine, but you are not looking for issues that do not have any label (which is not the same as "has a label which is not X", which is what your search says)