how do get a list of tickets from a deleted Sprint?

[Kent Chiu]

Is there a way to get a list of the tickets from a deleted Sprint?

One of our user deleted a Sprint that already had list of tickets assigned to it.  How can we get the list of the tickets so we can reassigned them back to a newly created Sprint?

I tried to use the JQL with the text ~ "Sprint name" but it does not work.

Thanks,

Kent

[Mohamed Benziane]

Hello @Kent Chiu 

Welcome to the community.

I just test it in my instance, the only way in found is to look at the history tab in each issue to see in which sprint the issue was. I found nothing in the report tab.

The "Formatio Sprint 1" was the sprint i deleted.

You can do it with a script using the rest API

GET /rest/api/3/issue/{issueIdOrKey}/changelog

Hope this helps

[Kent Chiu]

Thank you Mohamed for the suggestion. I am not that familiar with the API. I am willing to try. Do I need to have the issue key for {issueIdOrKey}? Does that mean we have to query for every key and check for the Sprint name? 

I can't believe such an important feature is not available from JIRA JQL functionality.

Thanks,

Kent