We need one report which will show all Jira statuses of sprint.

Question

Hi team

We need one report which will show us Jira status, at the start of the sprint and end of the sprint. This can be excel, dashboard, filter or any UI.

For this I have written one query and statuses are showing on the dashboard but the problem here is whenever a status is changed in Jira issue it is automatically updating in the dashboard as well. We need to get the actual statuses at the time of Sprint start/Close.

Query: sprint = 245

Thanks Regards,

Ravindra

Yuliia_Borivets__SaaSJet_ · Answer

Hi @nimmagadda_raveendra

Do you need to see the statuses for each issue? It seems you can check and export issue history (info about status changes across sprint). Read more about how to get it via REST API or plugins.

I can also suggest two solutions that are available with Issue History for Jira add-on.

1. Table view. Here you can filter by sprint and monitor how statuses were changing in chronological order.

In the example below, you can see two issues whose statuses were "To Do" at the start of the Sprint and "Done" at the finish. This way you can review the rest of the issues in Sprint.

2. Chart view. Here you can only monitor the general status changes for all issues in Sprint. This report helps to overview the progress your team has demonstrated. The ideal picture is when all issues are in “To Do” on the first day, the further you go the fewer issues should be in the first statuses (“To Do”, “In Progress”, etc.) and more in “Done”.

Issue History is developed by my team and it's free for companies with up to 10 users. Also, there is a 30-days free trial.

Check out if it can help with your case.

Aron Gombas _Midori_ · Answer

You won't be able to solve it with the built-in features.

But you could write a Groovy script for the Better Excel Exporter app which:

* Iterates over the issues* Check if the current issue's sprint is already processed* If not, connect to the REST API and get the sprint (with the start and end date)
* Add the sprint to the already processed one

* Iterates over the change history of the issue* Only check the change history items where the changed field is the status* Find the earliest AFTER the sprint start (it will be status of the issue at sprint start time)
* Find the latest BEFORE the sprint end (it will be status of the issue at sprint end time)

* Makes the data collected in step 1 available for the Excel template

You will find a lot of help in this page.

(PS. it's a paid and supported app developed by my team.)