Is there a way in JQL to indicate the LAST/Previous sprint closed?

[Kathy Dahmen]

I know that closedSprints() gives ALL sprints that have been closed.

I would like to be able to identify the 'last' sprint closed ... logically, the equivalent of closedSprints() - 1

Use case:  I'd like to identify all issues closed in the prior sprint given that we are now in an OpenSprints()

[Alexey Matveev]

Hello,

You can use the previousSprint jql function from the ScriptRunner plugin:

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_previoussprint

[Kathy Dahmen]

Thank you @Alexey Matveev ... that would work perfectly,  unfortunately we have 500+ user license for cloud, so for the 3 people who could benefit from this, the $600 price tag  per month is too steep.  :(

Perhaps any alternative that does not require the ScriptRunner add on?

Thank you!

- Kathy

[Moses Thomas]

@Kathy Dahmentry this

• Make sure you  have the script runner plugin for JIra
• issueFunction in previousSprint("<name of board>")

Best!

[Kathy Dahmen]

Thank you @Moses Thomas ... that would work perfectly,  unfortunately we have 500+ user license for cloud, so for the 3 people who could benefit from this, the $600 price tag  per month is too steep.  :(

Perhaps any alternative that does not require the ScriptRunner add on?

Thank you!

- Kathy