Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,676
Community Members
 
Community Events
165
Community Groups

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

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

2 answers

1 vote
yuliia_b__SaaSJet_ Marketplace Partner Jun 08, 2022

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.

status changes in jira.png

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”.

status update jira.png
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.

0 votes

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:

  1. Iterates over the issues
    1. Check if the current issue's sprint is already processed
      1. If not, connect to the REST API and get the sprint (with the start and end date)
      2. Add the sprint to the already processed one
    2. Iterates over the change history of the issue
      1. Only check the change history items where the changed field is the status
        1. Find the earliest AFTER the sprint start (it will be status of the issue at sprint start time)
        2. Find the latest BEFORE the sprint end (it will be status of the issue at sprint end time)
  2. 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.)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,121 views 34 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you