nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how can I filter issues not in active sprint (i.e. in backlog) for my dashboard?

C B9

I have configured my JIRA dashboard to show my 'In Progress' issues and 'Assigned to me" issues. The 'Assigned to me' includes both issues from the current sprint, and issues that are in backlog. What I want to create is a filter for 'Active in sprint' and another for 'Waiting in backlog', so I can more quickly see what I should be working on next. I can't see any existing filter attributes that will allow this.

My current filter is this;

issuetype = Story AND status in (Open, Reopened) AND assignee in (currentUser())

Is there some attribute that would support something like;

issuetype = Story AND status in (Open, Reopened) AND assignee in (currentUser()) AND xxx in (Backlog)

Accepted answers

Timothy

You can add "AND sprint is not EMPTY". Though the JQL will not tell you whether the Sprint is active or not.

EDIT: Oh wait, there is "sprint in openSprints()" that you can use.

All comments

Timothy

You can add "AND sprint is not EMPTY". Though the JQL will not tell you whether the Sprint is active or not.

EDIT: Oh wait, there is "sprint in openSprints()" that you can use.

Vidic Florjan

1. JQL for Backlog: With Script Runner plugin (by Jamie Echlin) installed you can try: issueFunction in inSprint("My board", "Backlog")

General Function: inSprint(board name, sprint name)
Finds issues in the given sprint. This works for sprints that are not yet started, active, and completed sprints. Instead of the sprint name, you can also use the string "Backlog".

https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-inSprint(boardname,sprintname)

2. JQL for open Sprints: sprint in openSprints() (as Timothy already mentioned)

Vidic Florjan

Documentation from Atlassian:
https://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-Sprint

C B9

"AND sprint is not EMPTY" didn't work as a couple issues that had been in a sprint, but were moved back to backlog still open when the spring closed, were still listed. "sprint in openSprints()" seems to work better. Thanks.

C B9

I had developed my query initially in "Basic Mode", and switched to advanced mode to paste the query in my post. Now that I added the "sprint in openSprints()", JIRA tells me it's "too complex to display in Simple mode". Starting in Basic Mode had led me to believe the options were far more limited than they actually are.

unknown

I have found that to identify issues that are in the backlog, I have to say

sprint IS EMPTY OR sprint NOT IN openSprints()

That is to say sprint NOT IN openSprints() is not enough: it doesn't select issues that have no sprint field at all.

petry

There is an opened Request for that here:

https://jira.atlassian.com/browse/GHS-6036

Michel Latourne

I use successfully the following JQL query to match what the backlog list shows in JIRA scum plan mode, assuming project is "PRJ" and current active sprint is "Sprint 6":

project = PRJ AND (Sprint != "Sprint 6" OR Sprint is EMPTY) AND status in ("Open","In Progress") AND type not in (Sub-task,Epic) order by rank

Nathanael Coyne

It kinda makes sense if you think about it, that if there is no value in the sprint field then it can't compare it against a list of sprints, although confusing. My filter now works by checking for issues that are neither in openSprint or empty as well as neither in closedSprint or empty … so that hopefully is returning all issues that may or may not be included in a sprint (but not a closed one and not the currently running one) and then I can check for those issues with no story points assigned to create a view showing all issues requiring story point estimation (excluding stories in sprints that have already started or are now closed).

Nicholas Tuck

"sprint in futureSprints()"

Not sure if openSprints changed and futureSprints was added but openSprints seemed to show the active one.

Alexandra Bondareva

is sprint in openSprints()supposed to show issues from the backlog? For me it doesn't. I need to view issues only from the backlog for a specific component for the purposes of the backlog refinement.

Max Kloosterman

Hi,

The statement below seems to work for me:

Sprint not in (opensprints(),futureSprints()) or sprint is EMPTY

In addition to an open sprit I have a number of futuresprints where we prepare the next sprints.

NB. the order of the arguments is important. If for example the statement sprint is empty is placed before sprint not in etc it renders an empty set.

Kind regards,

Max

Pulkit Singhal_9dlw2b

Good one Martin. I used something slightly similar as well:

... AND (sprint is EMPTY or sprint in closedSprints()) ...

I used closedSprints() because if an issue wasn't finished in a previous sprint then that value is still present ... realized that the sprint field is more like a history/array.

MarthaSimons

... AND (sprint is EMPTY or sprint in closedSprints()) ...

MarthaSimons

thanks

Mike Sebastian

Thank you!

Pratyush Sahay_4gwz22

sprint IS EMPTY OR sprint NOT IN openSprints()

Worked well for me. Thanks. And the suggestion of closedSprints to count the ones in active as well is very useful too.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software

scrum