How to get count of bugs that got reopened

[vijaykishan]

Hi Team,

I am using classic project. Wanted to know How many bugs got re opened. Whats the best way to acheive this.

[Emre Toptancı _OBSS_]

Hello @vijaykishan ,

If you just want to see which issues were reopened (once or more), you can use a JQL query like below to search for those issues. This query returns all issues that were in Resolved status in the past and was transitioned from Resolved to, let's say, Reopened status. 

project = ABC and status changed from Resolved to Reopened

This query can find which issues were reopened but cannot say how many times.

In order to see the count, you can use our app Timepiece - Time in Status for Jira.

Time in Status mainly shows how much time eachissue spent on each status or on each assignee but it also has reports showing how many times each status and each transition was used for each issue. You can also get the averages and sums or those counts.

   

The good thing is, the reports are prepared using your issue histories so you won't have to modify your workflows and you will be able to report on your past issues as well.

All data can be exported as XLS, XLSX, CSV and can be accessed via REST API.

Timepiece - Time in Status for Jira

Emre Toptancı

[Mariana_Pryshliak_Saasjet]

Hello @vijaykishan 

You can try Time in Status for Jira Cloud, which generates a report on how long an issue has been staying in each status.

BUT it also generates a Status Count report, that becomes helpful in your case! So you can get data about how much time an issue has moved to each status. 

I hope you find it helpful

Best regards, Mariana

[Chris Buzon]

There are a bunch of ways you could do this, but the methods are dependant on how you want to leverage that information and which addon you might be using, if any.

For example, you can create a post function that labels any bug that has been reopened with a specific label, then you can query for issues with that label (and combine it with more JQL for better results)

If you would prefer to know how many times a specific issue is reopened, you could leverage the automation scripts and store that information in a field, or as an automated comment, or as a label. and update that field each time it happens.  Smart values are extremely powerful!!

You can also make a fairly complicated JQL query to determine this, but it's a bit specific to just rattle it off.  You'll want to look up the "was in" operator found here, and combine it with a specific timeframe clause.  That can be piped into a dashboard widget so you only have to figure out the JQL once.

There are also several add-ons that can accomplish this out of the box.

If you have a specific requirement, let us know and we can suggest something more tailored to your situation.

[zacharoula_brinia]

@Chris Buzon Hello,

What automation rules do you suggest? Can you show me, please?

Thank you!

[Mehmet A _Bloompeak_]

Hi @vijaykishan ,

If you have a status named "Reopend" you can get the list of all reopened issues with the below JQL.

status was Reopened

If you do not indicate reopened issues with a specific status, you can use Status Time app developed by our team at Bloompeak. It provides various reports and one of them is Status Count report. Here is the online demo link, you can see it in action and try.

I hope, you find this helpful.

[tokcum]

Hi @vijaykishan

could you please be a little more specific about your request. What about a bug reopen twice? Would you like to count it twice? Do you also have a timescale in mind, like "number of bugs reopened last month"?

[Niranjan]

Hi @vijaykishan ,

Here is a similar discussion - https://community.atlassian.com/t5/Answers-Developer-Questions/Increase-by-1-a-custom-field-everytime-a-bug-is-reopened/qaq-p/511109

[Niranjan]

@vijaykishan - With script runner plugin you can create a scripted field - 

No. of Times In Status

https://scriptrunner.adaptavist.com/latest/jira/script-fields/no-of-times-in-status.html