How to find issues added to active sprint in JIRA?

19
votes

We use corkboard with printed Agile Cards. I would like to be able to create filter in JIRA's Issue Navigator to find issues that were added to the active sprint in the last 24 hours, last 2 days, etc. That way I wouldn't have to manually select new issues for printing everyday.

I've tried to write JQL query for this, but I only got this far:

project = "Our Project"
AND sprint = 1002
AND (created >= -1d OR (updated >= -1d AND status WAS Open BEFORE -1d))

This is not satisfying because:

  1. Sprint id isn't automatically selected (activeSprint() or something similar).
  2. Query doesn't actually answer my question.
2
jirajql
#1 "sprint in openSprints()" might help you – rcourtna
@rcourtna it did help me, thank you! – beam022
@rcourtna why do you write that up as an answer? – SpoonMeiser
There is a change request at Atlassian to allow 'historical operators' (WAS, WAS NOT, ...) to work with the Sprint field. Here's the link, in case you want to upvote it. – Jir
@Jir upvoted, thanks for sharing the link – beam022

2 Answers

21
votes

You can find issues in the current open sprint with the JQL clause:

sprint in openSprints()
1
votes

I don't think you can achieve what you asked for using the standard JQL, I think you'll have to create your own JQL search, check Adding a JQL Function to JIRA for how-to.

Another option would be using one of Jira's remote API to manually get the issue list.