How to find issues added to active sprint in JIRA?

jira jql
beam022 picture beam022 · Feb 28, 2013 · Viewed 15.3k times · Source

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.

Answer

rcourtna picture rcourtna · Mar 11, 2014

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

sprint in openSprints()

Related questions

JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

I am trying to create some Issue Filters in JIRA based on CreateDate. The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc. The only problem with this …

Read More
JIRA: Searching for all issues with a given link type

Is there a way to query for all issues with a particular link type? For example, let there be a dependency link where an issue can "depends on" another issue. Is there a query to find all issues that depend …

Read More
How do I query Jira to search for all issues that have been resolved within a length of time from when it was created?

For example, let's say I need to find all issues that were resolved within 1 week's time. I need something like: resolved - created < '1w' Another example: Let's say I have 3 issues: 1) created 2 days ago, resolved 1 day ago. 2) created 5 …

Read More