Can we get 'Issues removed from sprint' data in a Gsheet?

[Shubham R]

Let's say our report is set for periodic refresh and we don't have the data for comparison. Is there any way that we can pull the removed issues from JIRA from a sprint through JQL?

[Walter Buggenhout · Accepted solution]

Hi @Shubham R and welcome to the Community!

I don't think that is going to work very easily. In order to do what you are after, you should be able to filter for issues that were in a certain sprint, but then later on were removed again. Since JQL does not support history searches on the sprint field, there is no supported query for you to execute.

There is a feature request to add history searches on the sprint field that you can track here: JRACLOUD-39256.

As a workaround, you could have a look at the built-in Sprint report, where a separate section does list issues removed from the sprint. Or you could have a look at EazyBI, which has measures available to expose these issues as well.

Hope this helps!