Issue Summary

Currently, Jira does not have a native JQL function to retrieve the most recently closed sprints, such as the last 3 or 5 closed sprints. This functionality would be valuable for customers who need to access this data for reporting, performance tracking, or integrating it into other workflows and processes within their organization.

Steps to Reproduce

N/A

Expected Results

lastClosedSprints(<n>) – where <n> represents the number of most recent closed sprints to retrieve (e.g., lastClosedSprints(3) for the last 3 closed sprints).

Actual Results

closedSprints()

Workaround

As of now we can use the below JQLs
1. sprint in (closedSprints(), "Sprint Name 1", "Sprint Name 2", "Sprint Name 3")
Replace "Sprint Name 1", "Sprint Name 2", and "Sprint Name 3" with the actual names or IDs of your last three closed sprints.

2. sprint in closedSprints() and resolved >= -6w
 If you are doing 2 week sprints you can update the resolved date to be specific to the # of weeks for the 3 closed sprints. 

3. sprint IN closedSprints() AND resolved >= "2024-11-01" AND resolved <= "2025-01-01" 
Use date range fields to specify a more flexible timeline