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

[Krishna Kumar Yara]

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

[Trudy Claspill]

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?

[Krishna Kumar Yara]

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

[Trudy Claspill]

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.

[Nic Brough -Adaptavist-]

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)