JQL Help for Including the Last Several Sprints

Question

Hello All,

I am looking for some help on how to write a JQL query that includes data from the last 5 or so sprints. The number of sprints looking backwards can be flexible, but I am hoping to find a way to use the "closedSprint()" value to only look at a few sprints back.

Any recommendations?

Riley Piper · Answer

Hello @Inactive Stephen

I am looking for a way to look back on completed issues the last 3 sprints. The purpose of that dynamic field is really just so we do not have to go in and manually update the sprints in the filter at the close/start of each sprint.

Anna Hryhoruk _Appfire_ · Answer

Hello @Riley Piper ,
If you are considering using the application for this task, you can probably check Power Scripts for Jira. Using its JQL functionality, it is possible to establish JQL custom keywords that are associated with a custom script. This allows for the implementation of any required logic within the script.
If you are interested, please visit these pages for more details: JQL Support, Custom Keywords, and also adding a link to the list of sprint-related functions that can be used for script creation Sprint Functions.

In case you try this approach but face any issues or questions, feel free to create a support request here and share more details about your particular use case.

Hope it helps!
Anna

Ste Wright · Answer

Hi @Riley Piper

What data do you want to see from the JQL?

For example is it anything which was in the last 3 sprints? Or just issues closed within that timeframe? Or...?

Ste