How to find issues added to active sprint in JIRA?

Question

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:

Sprint id isn't automatically selected (activeSprint() or something similar).
Query doesn't actually answer my question.

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](https://jira.atlassian.com/browse/JRA-39256). — Jir, Oct 08 '15 at 09:04

score 19 · Answer 1 · answered Mar 11 '14 at 14:52

19

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

sprint in openSprints()

answered Mar 11 '14 at 14:52

rcourtna

4,361
5
24
27

1

But sadly there is no history of the sprint value supported. – mdoar Mar 11 '14 at 18:54
this will return all future sprints results as well. – Satyam Mar 28 '14 at 09:42
2

This answer doesn't answer the question at all - it could be useful for something... but not for what the requester asks for – Beauvais Oct 14 '15 at 13:05

Kuf · Answer 2 · 2013-02-28T15:06:18.113

1

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.

edited Feb 28 '13 at 15:06

answered Feb 28 '13 at 14:42

Kuf

15,678
4
61
85

That would select all the issues which status changed in whatever way (also the ones which went from "In progress" to "In review"). Issues in the backlog have "Open" status, so does the ones in "To Do" list. So this query would not select issues added to the sprint in the last 24h. – beam022 Feb 28 '13 at 15:04
2

History searches do not support the 'sprint' field. – beam022 Feb 28 '13 at 15:09
didn't think so but though to give it a try, only i don't have this plugins so i can't test it myself. well than, seems like you'll have to do some programming to get what you're looking for. – Kuf Feb 28 '13 at 15:12

How to find issues added to active sprint in JIRA?

2 Answers2