The Title says is all.
I have a project with many sprints and need to create a list of sprints that have only the issues closed in a specific sprint.
Another alternative to get deeper if you want to know which parent issues in all open sprints (if you run several teams with several concurrent sprints across any JIRA project) had a status change between a date range. You could further qualify this by adding a time block to the start/stop. Throw this at a pie chart to identify what went to QA and what went to Closed, for instance, in this range. This only works if the sprint is still open; else name the sprint by name like others above.
AND sprint in openSprints() AND status changed during (2015-08-22, 2015-09-04)
sprint = 6486 and status was in (Closed,Done) during ("2019-09-17 11:45", "2019-10-01 11:28") and issuetype != Sub-Task and resolution not in (Duplicate,Killed)
This should get you the same data for Confluence query as the Sprint Report. Note that you have to put in the status, issuetype and resolutions as per your configuration of Jira.
Sprint name still doesn't work as it has an issue with spaces even though you put it in quotes...
Learn how to use two new reports for next-gen projects in Jira Cloud: Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...
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