Why does the query resolution != Cancelled report nothing found?

Greg Huber
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 11, 2021

JQL reports back the correct number of Cancelled issues when I use (resolution = Cancelled), but comes back with nothing found when I use the inverse (resolution != Cancelled). 

How do I search for issues that are not Cancelled?

1 answer

1 accepted

1 vote
Answer accepted
Kian Stack Mumo Systems
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 11, 2021

@Greg Huber, if you want to find issues that are still open, IE, has no resolution, you need to run a JQL like this:

 

resolution != cancelled or resolution is EMPTY

 

The first part of the query (resolution != cancelled) should return all tickets that have a resolution other than cancelled. The second part will return all tickets that are still open. 

 

Thanks,

Kian

Greg Huber
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 11, 2021

Thank you!  That works.

Like John Funk likes this
Kian Stack Mumo Systems
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 11, 2021

Glad I could help!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events