Is there a query to find out which tickets move from current sprint to future sprint?

[Sherwin Soriano]

I would like to find a way to query on which tickets that were scheduled in a particular sprint, moved out to a future sprint or to the backlog.

I am not sure on how to capture this data

[Natalia_Kovalchuk_SaaSJet_]

Hi @Sherwin Soriano!

Unfortunately, this information is not available using native Jira JQL only. Jira standard JQL can only show the current value of the Sprint field, not the past changes.

With JQL, you can get such data:

• Tickets currently in a sprint: sprint = "Sprint Name"

• Tickets that were in a sprint (if the sprint is closed): sprint in closedSprints()

• Tickets that are in the backlog (i.e., no active sprint): sprint is EMPTY

For your case, I can recommend trying Issue History for Jira app from my team. The app records all historical field changes, including Sprint changes. 

After the app installation, you can use the needed filters (e.g., select tickets by project, date range, updater, etc.), and in the Columns menu choose Sprint and get such a report: 

You will be able to see the exact sprint transition time, the person who made such a change, and the previous and current tickets' sprints. 

You can export such data in Excel or CSV formats. 

Here you can find more information: https://community.atlassian.com/forums/App-Central-articles/How-to-capture-sprint-changes-in-Jira/ba-p/2835900 

Hope this solution can help in your case. 

[Jasmeet Kaur]

Hello @Sherwin Soriano 

Welcome to the Atlassian Community!

The Sprint field in Jira is multi-valued, it keeps a history of all sprints an issue has ever been assigned to (not just the current one).

If an issue was in "Sprint A" and then moved to "Sprint B" or the backlog, the Sprint field will show both sprints for that issue.

JQL to Find Issues That Were in a Sprint

To find all issues that were ever in a specific sprint (even if they are now in another sprint or backlog):

Sprint = "Sprint A"

This will return all issues that have "Sprint A" in their sprint history, regardless of their current sprint assignment. 

JQL to Find Issues Now in a Future Sprint

To find issues that were in "Sprint A" but are now in a future sprint:

Sprint = "Sprint A" AND Sprint in futureSprints()

Or, to find issues that were in "Sprint A" but are now in any open sprint:

Sprint = "Sprint A" AND Sprint in openSprints()

You can also combine with your project key:

project = "YOURPROJECT" AND Sprint = "Sprint A" AND Sprint in futureSprints()

This will show issues that were in "Sprint A" and are now scheduled for a future sprint

JQL to Find Issues Moved Back to Backlog

To find issues that were in "Sprint A" but are now in the backlog (i.e., not assigned to any active or future sprint):

Sprint = "Sprint A" AND Sprint not in openSprints() AND Sprint not in futureSprints() AND statusCategory != Done

This will show issues that were in "Sprint A" and are now unassigned from any sprint and not completed.

JQL cannot show the exact movement event (e.g., "moved from Sprint A to Sprint B on date X") without  checking the issue history manually.

Jira Sprint Reports (in the UI) do show which issues were completed, moved to future sprints, or moved to the backlog at the end of a sprint, but this is not available as a JQL query or exportable table.

[Trudy Claspill]

@Jasmeet Kaur 

If an issue was in "Sprint A" and then moved to "Sprint B" or the backlog, the Sprint field will show both sprints for that issue.

That is not entirely true.

If Sprint A is completed and as part of the sprint completion process the issue is moved to the backlog or another sprint, then Sprint A will be retained in the issue history.

If Sprint A is still active and you pull an issue out of it and put it into the Backlog or another sprint, then Sprint A is removed from the issue's Sprint history.

[Rahul_RVS]

Hi @Sherwin Soriano 

You can also use Jira Rest Api's to pull this information and build your own custom solution.

However if you need detailed reporting to track sprint changes for multiple issues, you may want to have a look at a mktplace app for the same.

We have built an app to extract changelog data in a simple and easy to use interface.

Issue History Reports

Do give it a try.

Disclaimer : I am part of the app dev team

[Alexey Pavlenko _App Developer_]

Hi @Sherwin Soriano ,

I investigated pretty well previously how to achieve it natively - unfortunately, it's impossible. You need at least ScriptRunner for that and their function 'was removed from sprint'. Another option is the app I developed - Multi-team Metrics & Retrospective. Thanks to it, you will be able to visualize it (look at Removed Scope) and even retrospect it.

For retrospectives - please read this article.

Best regards,
Alexey

[Petru Simion _Simitech Ltd__]

Hi @Sherwin Soriano ,

If you are open to using apps you can use Issue History Dashboard for Jira (Work Item History) , an app released by our company.

You can search by Field Updated = Sprint and you can see how the value was changed in columns Value From, Value To.

Regards, 

Petru