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."
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG