The Tip of the Month, brought to you by Atlassian University, is a monthly series
to help master Atlassian tools. Products are more fun to use when you
know all the tricks.

Sometimes it’s helpful to run queries on your current sprint or past sprints to better prepare for the sprint retrospective. November’s tip of the month focuses how to use JQL in the context of sprints. I’ll focus on JIRA Agile 6.3, but some of the features do work in prior versions of JIRA Agile.

Calling a sprint out

Sometimes you want to explicitly reference a sprint. JIRA’s autocomplete makes searching for a particular sprint easy, even if several teams use the same naming convention. Let’s look for “Sprint 2″.

jira_agile_jql_sprint_by_name

In the autocomplete dialog, we can see several key bits of information:

  • Sprint name
  • Sprint start date
  • Sprint ID

We can use this information to help narrow down which sprint is the one we are looking for. If we know the project key(s) that our sprint contains, we can add that to the query for a stronger search.

jira_agile_jql_sprint_by_name_2

The project=cis will only return issues from the CIS project. Thus if another team is using “Sprint 2″ as a name and we choose that one, our query will not return any issues. We can then choose the other option in the dropdown list. You can use either the sprint name or ID as the predicate. In other words, sprint = “Sprint A” and sprint = 223 would be equivalent.

Want to hang in multiple sprints?

There are three functions in JQL that allow you to query your agile projects:

  • closedSprints() – Returns issues that are contained in a sprint that has been completed.
  • openSprints() – Returns issues that are contained in a currently active sprint.
  • futureSprints() – Returns issues that are scheduled for a future sprint (and not in the backlog).

Missing the sprint commitment is really important to track for agile teams. Let’s see how we can find issues that slipped from a prior sprint into the current sprint.

1
Sprint IN closedSprints() AND Sprint IN openSprints()

Running this query right before the team’s retrospective can focus the team on which issues did not meet a prior sprint’s commitment. Reviewing these issues can give the team invaluable information on how to become better at estimation.  You can go even further by customizing search results to include the sprint column. Click the columns dropdown in JIRA 6.1 to add the sprint field. If you are using a prior version of JIRA, check out my configuring search results blog.

jira_agile_jql_sprint_by_name_3

Want to learn even more? Check out the docs about using Sprints in JQL. New to JQL? Check out my JQL primer!

If you found this helpful, please visit Atlassian University — interactive
tutorials and videos with tons of tips just like this
one.