CODEWITHSUNDEEP
jirajql
beam022
beam022

Reputation: 1833

How to find issues added to active sprint in JIRA?

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.

Upvotes: 19

Views: 25575

Answers (3)

philu
philu

Reputation: 874

If you have the Adaptavist extension, then you can do this:

project = "Our Project"
AND sprint in OpenSprints()
AND issueFunction in addedAfterSprintStart("<the name of your scrum board>")
AND (created >= -1d OR (updated >= -1d AND status WAS Open BEFORE -1d))

The key is to leave out the second parameter, the sprint number, of the addedAfterSprintStart function.

Upvotes: 0

rcourtna
rcourtna

Reputation: 4639

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

sprint in openSprints()

Upvotes: 21

Kuf
Kuf

Reputation: 17846

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.

Upvotes: 1

Related Questions