Report to see reopened issues

[Suma Pralhad Kustagi]

Hi,

  Is there any report where we can see the reopened issues, In history we get to know the status was reopened but do we have any report which shows reopened issues for a project.

Regards,
Suma

[Fabio Racobaldo _Herzum_ · Accepted solution]

Hi @Suma Pralhad Kustagi ,

you can create a filter with a JQL that use WAS clause. Example :

status WAS Reopened

That filter can be used in a gadget at your convenience.

Hope this helps,

Fabio

[Suma Pralhad Kustagi]

@Fabio Racobaldo _Herzum_ The issue is like the status Reopened is happening multiple times , close to reopen again reopen to closed etc..

[Fabio Racobaldo _Herzum_]

ciao @Suma Pralhad Kustagi , 

using WAS clause, you  will retrive all issues that was in that status at least once. What's your requirment?

[Suma Pralhad Kustagi]

@Fabio Racobaldo _Herzum_ Requirement is i want to have custom report where in it shows how many times it was reopened for a particular issue..

[Fabio Racobaldo _Herzum_]

So your requirement is different from the description :)

In order to have information about how many times an issue was in reopened status you should use a Scripted/Calculated field provided by https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?hosting=server&tab=overview

If you have chance to use that plugin I can provide you the code to add to that Custom Field

Fabio

[Suma Pralhad Kustagi]

@Fabio Racobaldo _Herzum_  Yes we do have this plug-in in use..It would be great if you can share across. Please let me know if any info required from my side..

Thank you :)

[Fabio Racobaldo _Herzum_]

So you need to :

1. create a calculated field with a name at your convenience.
2. Add the following code to Manage Apps -> Fields -> YOUR FIELD NAME

import java.util.List;
import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.issue.changehistory.ChangeHistoryManager;
import com.atlassian.jira.issue.history.ChangeItemBean;
ChangeHistoryManager changeHistoryManager = ComponentAccessor.getChangeHistoryManager();
List<ChangeItemBean> items = changeHistoryManager.getChangeItemsForField(issue, "status");
int result = 0;
for(ChangeItemBean ci : items){
if("Reopened".equalsIgnoreCase(ci.getToString()))
result++;
}
return result;

Use Number field as template for the field.

Let me know if it works.

Fabio

[Suma Pralhad Kustagi]

Please let me know if  I have missed anything. Not sure where to put in the code.

 

[Suma Pralhad Kustagi]

In Behaviors we need to add the code snippet ??

[Fabio Racobaldo _Herzum_]

@Suma Pralhad Kustagi u used a custom field provided by scriptrunner (https://scriptrunner.adaptavist.com/6.9.0/jira/script-fields/no-of-times-in-status.html) it should work.

My code is for "Scripted Field" custom field.

[Suma Pralhad Kustagi]

@Fabio Racobaldo _Herzum_  The field value says 0  for all the issues of particluar issue type.. Is it the right way ??

[Fabio Racobaldo _Herzum_]

@Suma Pralhad Kustagi for both solutions, try to see result using Preview Issue Key with an issue that was transitioned to Reopened status at least once.

[zacharoula_brinia]

Hello! Is this plugin free?

Thanks!

[Fabio Racobaldo _Herzum_]

hey @zacharoula_brinia , 

no, it is not free. Here more information about pricing https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?tab=pricing&hosting=datacenter

[Rustem Shiriiazdanov _Actonic_]

Hey, if you're open to marketplace solutions, let me recommend Report Builder by Actonic https://marketplace.atlassian.com/apps/1216997/report-builder-jira-reports-and-data-analysis?hosting=cloud&tab=overview for you.

Below is an example of Created vs. Reopened report available in the app, which you can use to effectively report on your reopened issues.

The advantages are:

• No need to introduce custom fields; the report will automatically detect reopen situations based on Jira status categories.
• There's no requirement for JQL; simply select the projects you need to report on, and you're all set.
• You can examine issues that have been reopened individually using the table view beneath the graph, or get an at-a-glance overview of the overall situation with reopen cases.
• The report is real-time, accessing issues immediately, ensuring you are always up-to-date with the latest data.
• You can export the report in various formats, share it within the app, place it on a Jira dashboard, or embed it as an iFrame on a Confluence page.

Regards,

Rustem