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?

[Thomas Ehardt · Accepted solution]

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()))

[Meetu]

thanks a ton it resolved my query too!

[Roberto T]

Very well observed

[Deleted user]

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

[Jane Ansara]

i need this too

[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

[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()))

[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.

[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  

[Alejandro Sanchez]

Worked like a charm, Thanks!

[Sandy Greenberg]

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

[Justin Hoffman]

This worked for me. Thanks, everyone.