I am able to build a query for finding issues that currently have or previously had, a status of Reopen.
Ex: status was in(Reopened).
I need help in build a query in finding the number of times a issue got re-opened?
JQL is only meant to return issues - it can't tell you how many times an issue was re-opened by default. You will have to go into the issue history for that.
However, you could add a field to the issue to track the number of times that an issue got reopened, and have that value increment each time the issue is reopened. This is possible with the JIRA Misc Workflow Extension:
which allows you to Increase the value of a field (which would work perfectly for this case).
Thanks Simon. Much Appreciated..!
I had a look at the URL for JIRA Misc Workflow Extension.
It looks, I need to Install the plugin by copying the JAR to WEB-INF/lib inside your JIRA web application and restart JIRA.
Kindly note, i am not a administrator. Hence, I am having the limitations of implementing it.
I am having user level privellages. To track my project very closely, I need to build a query to find the number of times the JIRA got reopened.
Do we have any other workaround.
We are having a similar issue where we want to have a first glance at how many times a cases was reopened without having to go through the history.
What you mentioned above could help us out greatly, but we are using the cloud based version of Jira. Is there anything similiar to JIRA Workflow Entension that we can use?
Workflow flow extentions are available on OnDemand. Please raise a support request to get it enabled for you.
EIDT: You can do it yourself - https://confluence.atlassian.com/display/AOD/Disabling+or+Enabling+a+JIRA+Plugin
You can have a field that is not shown on the screen of the issue on create, edit, etc. but update it when it goes through a transition of "reopen" or something equivalent. Then you can query for that field having the specific value.
This is only a half solution, as it can check if something has been reopened at least one time and is easy to implement.
As for a full solution, either using a plug in or writing a custom script that can increment a counter on a field is your only real solution.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...
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