Filtering backlog from project

[Robin Arnold]

I'm trying to add to this query to filter out only 'backlog' statuses in 'EINF'.  Is this possible?

project in (DIT, EINF) OR "Agile Team" = Infrastructure ORDER BY Rank ASC

[Robin Arnold · Accepted solution]

I figured out my own question :) 

project in (DIT) OR project in (EINF) AND status not in (Backlog) OR "Agile Team" = Infrastructure ORDER BY Rank ASC

[Scott Theus]

Hi @Robin Arnold,

I found some JQL in another post that may help.  Try the query below (I've put the new text in bold and italic)

project in (DIT, EINF) OR "Agile Team" = Infrastructure AND (sprint IS EMPTY OR sprint IN closedSprints()  AND sprint NOT IN (openSprints(), futureSprints()) AND status != Done) ORDER BY Rank ASC

Here is what the added JQL does

Include 

sprint IS EMPTY  OR  sprint IN closedSprints()

• Items that have never been assigned to a sprint (sprint is EMPTY) 
• Items that have been assigned to a previous sprint (sprint in closedSprints())

Exclude

sprint NOT IN (openSprints(), futureSprints()) AND status != Done

• Items in a "Done" status (status != Done)
• items in the current sprint (sprint NOT IN openSprints())
• Items in future sprints (sprint NOT IN futureSprints())

Hope this helps, for more info on how this was developed you can visit the original post

-Scott