How to know how many issues were reopened for user?

The easy answer would be "use status WAS reopened" but it doesn't help me in the case that a particulary issue were reopened several times for different users. So I need to know how many reopened issues have each user.

For example if a issue were reopened 2 times for different users then my result should be



User1 1

User2 1

If I export to xml a result from a filter it doesn't help me either because it doesn't have an history of the issue in order to know who was the user responsable to the reopened.

Any suggestion?

4 answers

This widget could not be displayed.
Gary Sackett Atlassian Team Jan 16, 2013

Hi Kamei,

Using the issue navigator, or JQL in the issue navigator will only net you the tickets that were re opened, and each one as a single line item. Unfotunately, there is no way to show the count of how many times they were re opened, or to have them show as multiple line items in the issue navigator. You may be able to grab this data using the REST API though:



This widget could not be displayed.

Just to clarify, are you saying that you want to collect data for issues that were reopened, but what you want to know is of those reopened issues, the person who reopened it, and if was reopened multiple times, know all the different people who reopened it?

I can't think of a way to do it from your example, but what you could do (mind you this is most plausible if you have a small user base) is search:

status WAS "Reopened" by user1

You could run the search for each user and find a way to compare the results (merging exported excel sheets?). Not optimal, but possible.

Hi Nat,

1. Using your query I get the issueus that were reopened, no matter what their status is.

2. How do I know who is the developer that resolved the bug that was reopened by QA?




If you want to modify it to also be at a status (I'm assuming you were thinking Reopened for that as well?), then:

status = "Reopened" AND status WAS "Reopened" by user1

As for #2, there's no easy way I can think of; you would have to look at the history of the issue, or again you would have to do another search using this query, and then find a way to merge the data with the previous results to get everything in the same place:

status = "Reopened" and status WAS "Resolved" by developer1

It's worth noting that, although it won't help with data you already have, for the future you could use some tricks with scripts and/or plugins to collect that data in a way that is more easily searchable.

This widget could not be displayed.

Any complete solution?


This widget could not be displayed.

I guess you got multiple solutions from your other closed thread - (just create a custom field and store the value while resolving (or in which ever status you want to capture) an issue)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

204 views 1 3
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