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

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