Jira query for the current version or sprint

by Brad on October 17, 2011

Jira dashboard widgets and the Rapid Board both can be built from any Jira query (JQL). It’s often useful to create a report or rapid view board that reports on the current sprint, or latest sprint. Here is the JQL that will show all issues in the current sprint (Fix Version) for a project named ‘WEB’, using the latestReleasedVersion() function:

project = WEB AND fixVersion > latestReleasedVersion(“WEB”) order by “Project Rank” ASC

There is a catch: you must manage your project’s versions so they are listed in the correct, reverse chronological order. Project administrator rights are required to do this, and it’s done on the ‘manage versions’ page. ┬áNote that the versions on this page must be in reverse chronological order, with newest at top, and oldest at bottom. You must also use the Jira ‘release’ function to release (close out) versions/sprints when they’re finished.

Ryan C March 20, 2013 at 8:52 am

sprint in openSprints()

Previous post:

Next post: