Query not returning all the results

[Bruce_ Luke]

I am using a very basic query project = UBT AND status in ("Awaiting Test", "In Test") AND labels != 'VerticalSlice' order by created DESC

This does not bring back all tickets that are in these statuses. 

I looked at your work around on article https://jira.atlassian.com/browse/JRACLOUD-78540

This bug has supposedly been open for 3 years which is rather concerning.

When I follow these steps I can find the project ID but the project ID isn't on https://esg-uk.atlassian.net/rest/api/3/status

Why can't you make the status IDs simply visible on the front end? Also can this search be fixed I would expect such simple functionality to work. If there's another way to get my status IDs in meantime please let me know.

[Dave Mathijs · Accepted solution]

Hi @Bruce_ Luke welcome to the Atlassian Community!

Which issues are you missing? Issues without labels?

Then maybe change

AND labels !='VerticalSlice'

into

AND (labels !='VerticalSlice' OR labels is EMPTY)

[Bruce_ Luke]

Thanks for speedy reply. The issue isn't label its the status. Im not getting all the items in those statuses. If I removed the label part and do a standard query or JQL query it doesn't return everything in these statuses. 

[Bruce_ Luke]

I found an easy way to get the status ID. I viewed the XML on the issue wasn't appearing on my search but combining with Daves suggestion it appears to work now. Thanks :)

[Dave Mathijs]

I would suggest to look for an issue that is not appearing in your search results as expected and try to discover which criteria hasn't been met.

You query will only show issues from project "UBT" in status "Awaiting Test" OR "In Test" which don't have the label "VerticalSlice"

I wont show issues without a label but in those statuses in that project.

[Bruce_ Luke]

Thanks Dave yeah the label part is still causing a little pain as I want to filter out that label but not any other label or no label

[Dave Mathijs]

Then try

AND (labels !='VerticalSlice' AND (labels is EMPTY OR labels is not EMPTY))

[Bruce_ Luke]

Nice one thanks again Dave.