JQL to find most recent closed sprint?

Matthew Campbell Jr August 25, 2015

I want to create a filter that will pull all issues from the most recent closed sprint. I see that I can do the filter of...Sprint in closedSprints()...but that gives me all closed sprints in all history of time of our JIRA instance. I only want the most recent closed sprint. Ideally I would like to find issues in closed sprints after a certain date.

Anyone know if that is possible and how to do it?

2 answers

5 votes
Steve Behnke [DiscoverEquip.com]
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.
August 25, 2015

I see the same question was asked in 2013, here: https://answers.atlassian.com/questions/235407

I did some digging around the Atlassian JIRA tracker for the Agile project and I didn't see a request along the same lines, so I made my own. You may vote up and comment on the feature suggestion here: https://jira.atlassian.com/browse/GHS-12432

I don't see any good work-around to return the results like you've requested, unfortunately. 

Steve Behnke [DiscoverEquip.com]
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.
August 25, 2015

I should note, if you need release management to this degree, I would emphasize the use of the Versions fields. I see a lot of teams NOT using Versions, and trying to get functionality available in the Versions fields on the Sprint mechanic. This may not be the case with you but I thought I'd mention, as Versions have a latestReleasedVersion() JQL function.

Daniel Rodriguez March 11, 2024

There is another related ticket https://jira.atlassian.com/browse/JRACLOUD-79678

0 votes
Matthew Campbell Jr August 26, 2015

Thanks Steve

Steven F Behnke
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.
August 26, 2015

No problem

Aakash Chauhan May 3, 2020

Hey Steve, any update on this.

Suggest an answer

Log in or Sign up to answer