When I try to create a query for issues w/0 the label "v8_testing_needed"no results are shown, why?

[Heather Driscoll]

I created a query that displays issues within the sprint that does not contain the label "v8_testing_needed." When I do this, all of my sprint items are gone and nothing is displayed. However, I do have one work item with that label so all of the issues should be displayed minus that one. I did the filter "labels!= v8_testing_needed. What am I missing?

[Gor Greyan]

Hi Dear @Heather Driscoll
Try the following, it should be worked.

"labels!= v8_testing_needed or labels is Empty

[Heather Driscoll]

Unfortunately, I already tried this and it does show in the query the ones without this label. However, if there are items in the query that also have no label at all, it removes them from populating as well. 

[Trudy Claspill]

Hello @Heather Driscoll 

Do the other issues have other labels? Do any of the other issues have no labels at all?

[Heather Driscoll]

Hi Trudy,

3 of the issues have no labels and 2 issues have the label "v8_testing_needed" as well as another label attached to it. 

[Trudy Claspill]

To get the issues that have no labels at all you would need to add this to your query:

OR Labels is empty

You said that you have two issues that have the specified label along with other labels. You query will exclude those issues because they have the specified label.

If you want to exclude only the issues where the specified label is the only label on the issue, while including issues that have no labels or have the specified label plus other labels, I don't know the solution for that.

You might try doing an internet search to see if you can find posts that already exist on this topic. I did a google search for jira jql exclude issues that have only 1 specified label and a number of results came up.

[Heather Driscoll]

okay thank you. That is exactly what I am trying to do so I will do an internet search. Thanks

[Heather Driscoll]

This is what I tried and nothing populates. 

[Trudy Claspill]

Hello @Heather Driscoll 

Your syntax is incorrect.

I think if you tried to just execute the labels portion of your original filter you would find it would not return any results:

labels != "v8_testing_needed" and labels IS EMPTY

Try this

sprint="v7.4.16" and (status = "QA to Do" or status = "QA in progress") and 
( labels != "v8_testing_needed" OR labels IS EMPTY )

Put parentheses around the labels criteria and separate them with OR rather than AND.

I don't believe that is actually going to get you the results that you want, ultimately. I don't think the results will include issues that have the specified label plus other labels.