It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

resolution is empty vs unresolved

AbrahamA Dec 04, 2011


Can you please let me know what is the difference between jql statements

Find issues that do not have resolution:

resolution = unresolved


resolution is empty

When issue is created is resolution by default unresolved with database value null.



3 answers

0 votes
Nazia Tarannum Dec 04, 2011

When Resolution is empty(in database) then it shows on screeen that its UNRESOLVED

Hence, as per my understanding there is no difference when querying (JQL), the resultset is same.

0 votes
Aspect Infra Team Dec 04, 2011

By Atlassian meaning field "resolution" is pseudo-boolean

it interpretes as resolved if there are any value assigned to field and as unresolved if field empty

so other synonym for your request is

resolution is NULL

0 votes
JamieA Dec 04, 2011

There is unfortunately another possibility, that there is a resolution with the value "UNRESOLVED". I have seen this several times, normally happens when people export/import to and from jira via CSV.

And it's a bug imho that jira allow this to happen.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Marketplace Apps & Integrations

Webinar invitation: Generate custom Jira Cloud PDF reports and exports

Jira may be a staple part of your workday, but your colleagues, customers, business partners or an auditor might need information presented in a different format, that is easy to access and read. And...

65 views 0 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you