Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to find issues added to active sprint in JIRA?

Tags:

jira

jql

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.
like image 909
beam022 Avatar asked Feb 28 '13 14:02

beam022


People also ask

How do I find Jira issues after sprint start?

They show with a * ("Issue added to sprint after start time") next to them in the Sprint Report. The Burndown Chart records this as a scope change with 'Issue added to sprint' in event detail.

Can you add an issue to an active sprint in Jira?

To assign an issue to a sprint from the timeline: In the timeline of your plan, click the name of the sprint. The capacity details and a suggestion for issue assignment for that sprint will be displayed. Click Assign x calculated issues. The issues will be automatically assigned to that sprint.

Which report shows list of issues in each sprint?

The Sprint Report shows the list of issues in each sprint. It is useful for your Sprint Retrospective meetings, and also for mid-sprint progress checks.

How do I see all active sprints in Jira?

Open the board and go to the Backlog view to see a list of all the open Sprints and the issues in the Sprints. You need to use the Backlog view since the Active Sprints view appears to merge all the issues into one Sprint.


2 Answers

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

sprint in openSprints()
like image 192
rcourtna Avatar answered Nov 15 '22 15:11

rcourtna


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.

like image 33
Kuf Avatar answered Nov 15 '22 17:11

Kuf