There is a difference in the following two filters:
resolution = "\"Unresolved\""
resolution = Unresolved
The first only finds the issues where the resolution is specifically set to "Unresolved".
In the database these jira issues have "11000" in the resolution field, which is the id of the Unresolved resolution in the resolution table.
The second finds the issues that are newly created where the resolution field is untouched.
In the database these issues have "NULL" in the resolution field. Unresolved is then selected because its default.
I would expect to find all the issues with the second filter.
Am i doing something wrong?
Correct - this is breaking your system because it means "resolved". Jira does not know or care what any resolution option's label is, the rule is "field empty/null = unresolved, field with any value = resolved"
I would first change the name of "unresolved" to "broken resolution - do not use", that will fix your searching, and give you an easy way to spot issues that might be broken.
Then go through your screens, making sure that only "transition" screens include resolution, and those are only used on transitions that go from an open status to a closed one (usually not-green colour to green), and also check that "reopen" uses a post function that says "clear resolution"
Finally, you will want to have a look at the list of issues with the broken resolution - any that are in a non-closed status should really be fixed, blanking out the resolution.
Dear @Paul Brand,
I repeated your search queries. The first filter returned
The value '"Unresolved"' does not exist for the field 'resolution'.
Searching with either
resolution = "Unresolved"
resolution = Unresolved
returns the same amount of issues. Is it possible, that you Jira has a custom resolution named Unresolved?
I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
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