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,534
Community Members
 
Community Events
165
Community Groups

How to get all sprint wise completed issues list for whole project at once

How to get all sprint wise completed issues list for whole project at once-Need help in writing query

2 answers

Hello @Krishna Kumar Yara 

Can you explain your reporting need in more detail, and provide an example?

Are you trying to get a list of the issues completed in each sprint, for all sprints for a project?

Normally on scrum board we see all userstories under active sprint and a backlog.


My requreiment is to see all closed sprints with list of completed userstories listed under it for complete project. 

Sample requirement is shown below

  • Sprint 1
  1. User story 1 - Complete
  2. Userstory 2 - Complete
  • Sprint 2

1. userstory 1 - Complete

2. userstory 2 - Complete

From the Reports menu associated with the board you can access the Sprint Report. You can select one sprint at a time and view all the issues that were in it and which were completed.

There is not a native method to generate a single output set that shows each sprint and the issues completed in each. There may be a third party app in the Atlassian Marketplace that would enable you to get a single report with all the data.

0 votes

Welcome to the Atlassian Community!

Have a look at the board configuration, and check out what status are mapped into the last column on the board.   

Let's say you find "done", "closed" and "cancelled" as three status in that column, and your board is a simple "project = XYZ" board, then your query is

project = XYZ and status in (done, closed, cancelled)

Suggest an answer

Log in or Sign up to answer
TAGS

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