I would like to create a filter that shows issues that have been reopened in the last week, but there doesn't seem to be a 'reopened date'.
Does anyone have any suggestions for how I could do this?
Edit: we are using jira v5.1.1
Thanks, unfortunately we don't have that plugin currently, and our licence is for a few thousand users, plugins get quite expensive at that point so I won't be able to get it purchased without a *really* good reason either. Thanks for pointing this plugin out though, looks useful.
To get an exact clue of reopened issues you need to specify a custom field (reopendate) and add a post-function on the reopen transition that writes the current timestamp to the reopendate. with this, you are able to filter exactly those issues.
Done. I created the Custom Field ReopenDate and set the field type to Date Picker. Then I added a Post Function to all my workflows on the Reopen Issue transition (Update Issue Custom Field) as follows:
The ReopenDate of the issue will be set to %%CURRENT_DATETIME%%.
Then I temporarily added "Reopen Date" to my Default Screen so that I could manually update the field for existing issues that have been reopened but not yet closed, since they've already been through the transition. I'll probably remove that when done because I don't want users manually setting this field in the future.
Confirmed that I can query on this field for accurate information whether auto-filled as part of transition Post Function, or manually filled.
Only thing missing is that even when this custom field has data in it, it is not displaying in the Details section of individual issues.
Went back and double-checked and it is not on the view issue screen anywhere. Not critical for this particular custom field, as I can see the date under the Transition Summary, and I don't need users interacting with the field. Just wish I understood when a custom field gets displayed and when it doesn't.
As mentioned by Steve Korzinetzki, you can set the Reopen Date by adding the post function.
And then use Reopen Date for filtering/ searching Issue.
JIRA Suites - https://marketplace.atlassian.com/plugins/com.googlecode.jira-suite-utilities has a postfunction - https://jsutil.atlassian.net/wiki/display/JSUTIL/JIRA+Suite+Utilities+Workflow+Post-Functions#JIRASuiteUtilitiesWorkflowPost-Functions-UpdateIssueCustomFieldPost-Function
I guessed unless you create a custom date field to track the reopen ticket(copy the value using post function) if you really need to view the date as well.
Otherwise, the JQL proposed by Roman should help you to retrieve the past week issues that been in reopen state. :)
This is the kind of thing I was trying to do, I was thinking that the 'was' operator might help here, but I couldn't quite get the syntax right.
Based on what you suggested I'm now using the following query, which gives me all issues which are now reopened, but were in the 'resolved' status at some point in the last week. It's close enough to what I'm looking for. Thanks for pointing me in the right direction.
status = reopened AND status WAS resolved after "-1w"
For the moment, JIRA do not have the filtering to show the issue of reopened history. However, I can introduce a plugin known as JIRA Enhancer Plugin that contain of custom field where record issue reopened date. To download the plugin please click the link below:
You can try to test on it and see how it goes. Thanks, John
so which query is most suitable to get reopened bug count for past week
Project = TEST AND issuetype = Bug AND status WAS Reopened AFTER "-1w"
Project = TEST AND issuetype = Bug AND status changed to reopened after -1w
is there possiblity to get reopen bug count for any specific period than week using jql?
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in talking to 20 people planning t...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs