JQL to identify issues closed in last 4 Sprints?

[Alex Hadden-Boyd]

I'm trying to write a query to use in Structure, that collects all issues closed in the current and last 4 sprints.

[Stepan Kholodov _ALM Works_ · Accepted solution]

Hello Alex,

There is no JQL in Jira for writing such a query - there is no functionality that tracks the order of closed Sprints and the status of an issue is not tied to any Sprint. If you know the names of the last 4 closed sprints and issues are being closed before their sprint is closed, you can do the following in Structure Cloud:

- add closed issues to a structure or add any other scope of issues and apply filtering by closed issues afterwards;
- group them by Sprints and check the list of issues in the sprint-based groups you need.

I hope this helps. Please feel free to contact us directly at support.almworks.com if you need our assistance with anything else.

Best regards,
Stepan Kholodov
ALM Works

[Trudy Claspill]

Are you trying to query for specific, named sprints, or are you trying to build a query that will find issues in the current and last 4 sprints at the time the query is run?

[Alex Hadden-Boyd]

The latter; I know how to do the former.