Hello,
One of my customer asked me a question about the different results in using JQL belows :
Please let me know the difference of above two JQL.
Regards, JJ
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you.
I can explain the difference to my customer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Jongho Jung and thanks for your question.
You can following page might help.
Hope this helps.
Best,
Murat Seven
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.