CODEWITHSUNDEEP
jirajira-rest-apijql
eureka19
eureka19

Reputation: 3060

JQL: Find the latest closed sprint

How can I find the last closed sprint?I tried using 

ORDER BY updatedDate DESC

but this returns all the closed sprints. I need only the latest one.

Upvotes: 4

Views: 10421

Answers (1)

GlennV
GlennV

Reputation: 3650

JIRA does not provide a JQL function out of the box that supports listing the issues in the last completed sprint. The best it offers is displaying the issues in a sprint by name, e.g.:

sprint = "<sprint name>"

You can find the documentation about the JQL support for the sprint field here.

If you use JIRA standalone, then there are a few add-ons that provide additional JQL functions. For example, Script Runner adds a function previousSprint that does what you want. Your JQL then looks like:

issueFunction in previousSprint("<board name>")

There is also a cloud version of this add-on, but it does not support the agile functions yet. To see what they do support, check this table.

Upvotes: 1

Related Questions