How i can find all the issues that was on sprint after the sprint closes in Jql query?

Question

Hi,

I want the ability to get all the details that i have in sprint report  about specific sprint in JQL query.

Bill Sheboy · Answer

Well, that is curious.  The sprint value is added to the field when the sprint starts.  I thought that removing it from the sprint should not remove the value.

How are you moving the story before the sprint closes?

As an alternative, when a work item will not finish in the sprint, consider leaving it in place until the end, to preserve the history.

If removing things from sprints is happening frequently, consider pausing with the team to understand why and how to improve that.

Maya.herman · Answer

If i moved the story before closing the sprint, so i doesn’t have that sprint name in the field. This is why the JQL queries above don’t work for me.

Bill Sheboy · Answer

Hi, Maya!

First thing, here is the documentation on advanced JQL, which may give you some ideas: https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-operators-reference-939938745.html

Use this one to find the issues in a prior sprint and which are now in an open sprint:

project = myProject
AND sprint IN closedSprints()
AND sprint IN openSprints()
ORDER BY key

If you changed the status to Backlog as part of the move, you could refine that query a bit with:

project = myProject
AND sprint IN closedSprints()
AND sprint IN openSprints()
AND status CHANGED TO Backlog DURING (yyyy-mm-dd, yyyy-mm-dd)
ORDER BY key

For your second question about planned issues at sprint start, anything that was in the sprint when it started will have that sprint name in the the field.  For JIRA (and scrum), that is why it is valuable to confirm your scope before you start the sprint.