JQL Help for Including the Last Several Sprints

Riley Piper April 9, 2024

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? 

3 answers

0 votes
Anna Hryhoruk _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 10, 2024

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 scriptThis 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

0 votes
Stephen Wright _Elabor8_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 9, 2024

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

Riley Piper April 10, 2024

Hello @Ste 

 

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.

0 votes
Mark Segall
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 9, 2024

Hi @Riley Piper - Unfortunately, this is not possible with native Jira functionality and I'm not even sure that it's possible with a marketplace app.  It would likely require some form of scripting leveraging the API to pull that information.

Riley Piper April 9, 2024

I appreciate the quick response here Mark! Not a big impact for us as it was more of a nice to have. 

Like Mark Segall likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events