It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
  • Community
  • Products
  • Jira
  • Questions
  • I need to be able to find the issues closed in a specific sprint. We have issues that carry through multiple sprints and I need to "Trap" only the issues closed in a specific sprint. How can I do this?

I need to be able to find the issues closed in a specific sprint. We have issues that carry through multiple sprints and I need to "Trap" only the issues closed in a specific sprint. How can I do this?

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. 

 

 

4 answers

0 votes

Hey Shan,

You can run a JQL to search for the sprints you would like to. Please refer to this page for more details on how to achieve it.

-- Arthur Gonçalves

Similar to Arthur's comment

 

Get to the Advanced Search and start building statement similar to:

 

status WAS "closed" and sprint =  "Sprint 18"

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)

Thanks for the input 

 

I am trying some of these ideas now. 

 

 

If you can, let us know what you came up with to solve your question. Interested to see different solutions to an issue. Thanks!

Any luck?  I'm having the same issue.

Like Aaron Harrison likes this

I'm interested too. Did anyone find a good solution?

alison I'm New Here Oct 15, 2019

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

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

308 views 1 3
Join discussion

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