How to find issues that were removed from a sprint?

[Dharmender Yadav]

Hi everyone,

I'm trying to identify issues that were removed from a sprint after the sprint started. From what I know, the Sprint field doesn't support historical operators like CHANGED, which makes this tricky.

So far, I’ve considered these approaches:

1. Brute force approach 

1. Get all issues not currently in the sprint
2. Loop through their change-logs to check if they were ever part of that sprint and then removed

2. Updated issues within sprint window

Use something like:

JQL : updated >= "2025-05-24" AND updated <= "2025-05-27"


And then inspect these issues to check if they had a sprint removal event

Does anyone know of a better or cleaner way to find issues that were removed from a specific sprint? Better if we can find a way via JQL or Jira REST API.

[Natalia_Kovalchuk_SaaSJet_]

Hi @Dharmender Yadav !

Issue History for Jira app from my team may be able to help you with this. It tracks changes over time and can show when issues were added to or removed from a sprint, including after the sprint has begun. Also, it helps to see the issues where the sprint was changed.

Additionally, the app offers filtering and export options, which are useful for reviewing or examining changes in sprint scope during retrospectives.

I hope it can help you with your task of identifying issues that were removed from a sprint. 

[Aron Gombas _Midori_]

Export all issues with their "repeating" change histories to Excel (sample):

Use the standard Excel filter feature to narrow down your sheet:

1. to given time period
2. to the "Sprint" field
3. to a non-empty old value
4. and an empty new value

This sheet was created with the Better Excel Exporter app.

(Discl. this paid and supported app is developed by our team. Free for 10 users!)

[Mohamed Benziane]

Hi,

This is not possible, but you have a workaround in this request : [JRACLOUD-75868] JQL search for issues added and removed from a sprint - Create and track feature requests for Atlassian products.

[Florian Bonniec]

Hi @Dharmender Yadav 

You have the Report available for this if you know the Sprint Report that displayed the work item removed from the Sprint.

https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-sprint-report/

Regards

[Dharmender Yadav]

Hello @Florian Bonniec Thank you for your response. 

Is there any way to get the sprint report related data via JIRA API's or JQL ? I am specifically interested in knowing the removed issues from the sprint scope.

Thanks

[Florian Bonniec]

No there is no way I'm aware of using JQL nor API.

Regards

[Karan Sachdev]

Hey @Dharmender Yadav

Welcome to Atlassian Community!

You can review the Sprint report to get this info. Select Reports from the left menu in your board and go to Sprint Report.

Select the required sprint from the drop-down. The issues completed, not completed (moved to next sprint or backlog) and removed from the sprint are listed in the report.

Example:

[Dharmender Yadav]

Hello  @Karan Sachdev Thank you for your response. 

Is there any way to get the sprint report related data via JIRA API's or JQL ? I am specifically interested in knowing the removed issues from the sprint scope.

Thanks