How to get: Status Change (Story, Bug) during Sprint for ALL sprints

Question

Hi I need to know the number of bugs, stories that changed their status to REOPENED during a sprint, for ALL sprints automatically.

If i want to find the information for a single sprint, the raw data JQL is this one:

project in ("my project name") AND issuetype in (Story,Bug) AND status changed TO (Reopened) DURING ('2019-05-01','2019-06-04')

but i have to find all the sprints Start and End Date and manually execute the JQL for every sprint.

* Does anyone know how to automate the process? (find all sprints, find all the start and end dates, and for each set execute the query that sums the numbers)
* Is there a widget that will display the results on a dashboard?

Thanks

Ziv Shapira · Answer

Thank you @Tom Lister  where can I develop and execute these custom functions? Is it from inside Jira UI or on a local IDE, that connects to our account to pull the data?

We are using the Jira SaaS (under atlassian.com)

Ziv Shapira · Answer

Thank you @Raimundas Juska  I will look into this, we use Cloud Jira, so I am not sure we can add apps.

Raimundas Juska · Answer

Hi, I have an app suggestion that might do what you want - https://marketplace.atlassian.com/apps/1219761/individual-velocity-report-chart-gadget

It can measure committed/completed issues (velocity) per sprint. You can set a custom status when specifying completed issue calculation - in this case REOPENED. Then completed issues would show the number of issues changed to REOPENED during sprint.

You can test it with a trial version to check if it fits your needs as it is not exactly what it is designed for, but it might just work.