Forums

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

Difference between JQL resolution = Unresolved and resolution = "\"Unresolved\""

Jongho Jung
Contributor
November 6, 2023

Hello,

One of my customer asked me a question about the different results in using JQL belows :

  • assignee = "abc@abc.com" AND resolution = Unresolved 
  • assignee = "abc@abc.com" AND resolution = "\"Unresolved\""

Please let me know the difference of above two JQL.

Regards, JJ

4 answers

3 accepted

4 votes
Answer accepted
Walter Buggenhout
Community Champion
November 6, 2023

Hi @Jongho Jung,

The first JQL is the way to find all issues where there is no resolution filled out. Unresolved is a reserved keyword that lets you identify all open issues. The second one would return literally the issues where the value of the resolution is "unresolved". The backslash is used in JQL to escape special characters. However, with the resolution field, that does not make much sense. It would be a bit of a contradictio in terminis (using a field the says how something was resolved and then saying it isn't).

Hope this helps

Jongho Jung
Contributor
November 6, 2023

Thanks for your answer.

1 vote
Answer accepted
Muhammad Moazzam Hassan
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.
November 6, 2023

Resolution field have pre-define values like a Single Select Dropdown Field,

The first query is correct and will search the issues whose resolution is empty.

The Second quey is wrong because this notation is used to search text-based fields and this notation will search the text which exactly contains that phrase.

Jongho Jung
Contributor
November 8, 2023

Good answer, thanks.

0 votes
Answer accepted
Sanjen Bariki
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.
November 6, 2023

Hi @Jongho Jung ,

 

Welcome to Atlssian community.

Please find the answer below inline.

assignee = "abc@abc.com" AND resolution = Unresolved 
It means where the resolution field has not been set yet, and In other way which is unresolved issues in many issue tracking systems.

 

assignee = "abc@abc.com" AND resolution = "\"Unresolved\""
This might not work as expected in the systems as the value of resolution is typically stored without quotes. Resolution defined globally So don't need to user "\"abc\""

We need to use quotes in the comment and other text values not for here.

 

Regards,

Sanjen

Jongho Jung
Contributor
November 8, 2023

Thank you.

I can explain the difference to my customer.

1 vote
Murat Seven
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.
November 6, 2023

Hi @Jongho Jung and thanks for your question.

You can following page might help.

Hope this helps.

 

Best,

Murat Seven

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM Trial
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events