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

USER REOPENED

==============

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

0 votes
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:

http://docs.atlassian.com/jira/REST/latest/

Cheers,

Gary

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?

Thanks,

Janiv

Hi,

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.

Any complete solution?

Thanks

0 votes
Renjith Pillai Community Champion Jan 21, 2013

I guess you got multiple solutions from your other closed thread - https://answers.atlassian.com/questions/126139/reopened-statistics (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 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 ...

2,981 views 12 18
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