Reopened Statistics


I'd like to do some statistics on the reopened status:

1. How many bugs were reopened

2. Who is the developer whom his bugs fixes (resolved) were reopened most? Or, for each developer, how many bug fixes were reopened by QA?

3. How many times each bug was reopened?




1 answer

2 votes
Renjith Pillai Community Champion Jan 17, 2013

1. Use JQL status changed from Closed to Reopened

2. Add column Assignee to the issue navigator, if it is not present already

3. Use Misc WF extensions and use a calculated field to increase everytime an issue moves from closed to reopened


The assignee column presents the current assignee which does not help.

If the issue was reopened 2 days ago, and yesterday it was changed from reopened to resolved again, I cannot not who's resposnible for the reopened...

Please help.



Renjith Pillai Community Champion Jan 18, 2013

Why, it should still give you the results. Are you changing the assignee while reopening the issue?

Thanks, 1. The assignee is changing from the qa to the developer who resolved the bug 2. Anyway, I want a report from the past, no matter what the current status is. The bug may be now closed and assigned to the qa manager, but I still want it to be listed in the reopened report and count the times it was reopened and count the reopened for the developers. Thanks again, Janiv.
Renjith Pillai Community Champion Jan 19, 2013
Ah ok, then use a user custom field and copy the assignee field to this field during the transition to resolved. This value will give the last user who resolved it. Also you can use the custom field type 'last resolved user' from

Hi Renjith,

I followed your solution but I want to count for existing issues.

I want to write a mysql query to find out no of times an issue got reopened in his life time.

The issue might closed now but I want to know reopned issue count.

Is there any mysql query to know the count?

Much appreciate if I get solution.

Renjith Pillai Community Champion Mar 08, 2014
  1. You should be able to use the same solution to use a calculated field to be incremented everytime the issue moves to Open state (Resolved => Open)
  2. Or use the Scriped field from Script Runner to get the change history and calculate this automatically (need to write some groovy code though)
  3. If you are particular about a database query, then you need to join the jiraissue, changegroup and changeitem tables to a join to get this.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,327 views 14 20
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot