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

Question

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()

Kathy Dahmen · Answer

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

Kathy Dahmen · Answer

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_08kyb0 · Answer

@Kathy Dahmentry this

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

Best!