How to create a JQL query to list issues where Sprint field was changed to a specific Sprint within

[alexei.g]

Hello, Atlassian Community!

I need help creating a JQL query to list issues where the Sprint field was changed to a specific Sprint within a specific time frame.

Specific Sprint: SPRINT name .
Time Frame: From 2024-04-02 to 2024-04-05 .
Additional Information:

I want to retrieve a list of issues that had their Sprint field changed to the specified Sprint during the specified time frame.
Please provide the JQL syntax or guide me on how to construct this query correctly.
Thank you for your assistance!

[Walter Buggenhout · Accepted solution]

Hi @alexei.g and welcome to the Community!

I am afraid that is not possible today. Fir this to work, you would need to be able to do a history search on the sprint field and that is - unfortunately - not supported. There is a feature request for this that you can track here: JRACLOUD-75868.

It does describe a workaround which implies setting up a custom field and automation that may inspire you.

Hope this helps! 

[alexei.g]

I know that searching through history for the Sprint field is not possible right now. I was wondering if you could suggest any other options. Thank you very much.