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

[Ziv Shapira]

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. 

1. 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)
2. Is there a widget that will display the results on a dashboard?

Thanks

[Tom Lister]

Hi @Ziv Shapira 

You would need some custom JQL functions to get the dates.

You can use the Sprint as a value in dashboard gadgets. Would that work for you?

Tom

[Ziv Shapira]

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)

[Raimundas Juska]

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.

[Ziv Shapira]

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