Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Why is my JQL Query not filtering properly?

Taylor Treece
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!
January 16, 2019

I have created a filter to look for issues for a specific client and have the resolution of "unresolved". However, when executing the query I receive issues that have already been resolved and are completed. Here is the query I am using:

 

"client" ~ HCR or "Client Name"= "HCR" and resolution = unresolved

 

 

despite me setting the resolution to "unresolved" I am getting results back containing tickets that have Resolutions such of "Complete" as well as "Unresolved". 

 

I have also tried using the condition "resolution != complete" and am still getting issues that are marked as Complete.

 

I am attempting to only see the issues which are unresolved.

 

Any assistance would be great!

 

Thank you!

1 answer

1 accepted

1 vote
Answer accepted
Johan Soetens _Dumblefy_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 16, 2019

Hi Taylor,

you have a keyword OR and as you're not using any parentheses your statement will be evaluated left-to-right.

Taylor Treece
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!
January 16, 2019

Thank you for the quick response Johan. I added parentheses at the beginning and before "and" and it looks like that did the trick.

 

Thank you very much for the advice I am still learning JQL!

Johan Soetens _Dumblefy_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 16, 2019

You're welcome, there are many good resources out there and Atlassian also has nice video tutorials on their Training page.

Gain Project Insights Through JQL

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events