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

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.



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.
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.

  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.

Hi Renjith,

I know its old discussion,


i too want to get reopened count from an existing set of issues (closed or open )

Without using any extension is it possible ?

or can we get the coun directly from  the db using some query ?

@Renjith Pillai I like the ideas you suggestion under option 1. I understand the calculated field should be updated for example in a workflow transition. The issue is that the post-function to update a field, does not allow to update a custom field. So, I don't see how it can be implemented. Would you provide more detail for this solution? Thanks. David

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,282 views 5 10
Read article

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