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 to find issues in backlog using JQL with JIRA Agile?

Thomas Ehardt

I just upgraded from Greenhopper to JIRA Agile.

How does one search for issues in the backlog?

Accepted answers

Thomas Ehardt

It looks like this is how you would do it (equivalent to backlog view in planning board):

project = *project_name* AND issuetype in (Task, Bug, Improvement, "New Feature", Enhancement) AND sprint is EMPTY AND resolution = Unresolved and status != Closed

All comments

Thomas Ehardt

It looks like this is how you would do it (equivalent to backlog view in planning board):

project = *project_name* AND issuetype in (Task, Bug, Improvement, "New Feature", Enhancement) AND sprint is EMPTY AND resolution = Unresolved and status != Closed

Kristofor Carle

I discovered that Sprint = Empty is not enough if you have open issues that were once part of a previous sprint. Instead I ended up using the suggestion from this thread https://answers.atlassian.com/questions/142125

issuetype != Epic AND resolution = Unresolved AND  (Sprint = EMPTY OR Sprint not in (openSprints(), futureSprints()))

Justin Hoffman1

This worked for me. Thanks, everyone.

Sandy Greenberg

Brilliant! Worked for me too. Wish I hadn't spent a morning on it before Googling it though....

Alejandro Sanchez_ool9zo

Worked like a charm, Thanks!

unknown

Any Idea on how to do this with for projects without sprints?

Bart Molenaar

Had this annoying thing that when retrieving all issues from a sprint the amount was hardly ever equal to the amount shown in the backlog right to the sprint title.
Found often that issues where missing despite the fact that the retrieved number was in most cases higher.
However with this query it matches always the amount and same issues shown in the backlog sprints.

sprint=<sprint number> and issuetype not in subtaskIssueTypes() AND type != Epic

Meetu

thanks a ton it resolved my query too!

Cristianne Bastos

Don't know why Atlassian let us struggle with such a thing. This should be a default filter.

After many trials, I got this that finally returned the same amount of backlog items:

project = <Project name> AND issuetype not in subtaskIssueTypes() AND issuetype != Epic AND resolution = Unresolved AND (Sprint = EMPTY OR Sprint not in (openSprints(), futureSprints()))

F_ Wolf

Seems as if all of the suggestions are missing the "status != Resolved". So it basically should look like this:

project = <Project name> AND issuetype not in subtaskIssueTypes() AND issuetype != Epic AND resolution = Unresolved AND (Sprint = EMPTY OR Sprint not in (openSprints(), futureSprints())) AND status != Resolved

Roberto T

Very well observed

Jane Ansara

i need this too

Drew Lustro

So ridiculous. Thank you.

Scott Windus

Wow, so complicated for my non-coder brain. Thank you so much for working this out and sharing it.

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