I am looking to create a query to identify the number of unresolved tickets on a specific date. In the query below, I am attempting to find the number of unresolved tickets on April 1 2017. This returns no results while "resolution was not fixed" does.
created <= -42d AND resolution was Unresolved during ("2017/03/31", "2017/04/01")
What happens if you use this JQL?:
resolution was EMPTY on 2017-04-01
If this doesn't return anything and you definitely had unresolved issues on that date, then check that you haven't defined a resolution called 'Unresolved'.
Theres information about why that's a bad thing on this page: https://confluence.atlassian.com/adminjiraserver073/defining-resolution-field-values-861253253.html
"Don't create a Resolution named "Unresolved"/"None"
Any issue that has the Resolution field set is treated by JIRA applications as "resolved". The Issue Navigator displays Unresolved when no resolution is set for an issue. So adding a resolution named Unresolved/None and setting it in an issue will mean that the issue is seen as resolved. This will lead to confusion and is not recommended."
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.