query all issues in backlog

[Jo]

I need to bulk change all the issues that are still in the backlog.

But I cannot find the right query.

[John Funk · Accepted solution]

Hi Jo - why can't you just do Project = ABC and status = Backlog

[Brian Pipa]

Not all tickets in the backlog are in the "Backlog" status. Many are in OPEN or TODO.

[John Funk]

Then Project = ABC and status in (Backlog, Open, "To Do")

[b_gupta]

It does not work as there is nothing with Status = backlog

[John Funk]

Well, then what are you trying to bulk change then? If there are no issues in Backlog, then there is nothing to move out of backlog. 

[Pragnesh Patel]

Try this...

Project = 'ABC' and Sprint is EMPTY

[Lars Jendrzejewski]

@John Funk , you are ab-so-lutely right. If there are no issues, nothing is to move.

But why Do I see Issues in the Backlog and no Issues in the search when I use status = backlog ? Did the Jira-Manager make a wrong configuration because the Backlog is not a status? "Sprint is EMPTY" is giving me more Issues than in the backlog,

[Pragnesh Patel]

Lars - Along with Sprint is EMPTY make and condition --> AND Type NOT IN ( Subtask ).

[Lars Jendrzejewski]

Thx, I think i get near the search string. For Example I have issuetype not "Type" in the Cloud , but it´s the direction I needed. A little bit unfortune tho that we do not have the backlog term in the search area.

[Pragnesh Patel]

Gr8 - it helps to you. Not sure, but I am having "Type" in the Cloud.

[Fazila Ashraf]

Hi @Jo 

How about your board's filter query + and sprint is empty ?

I mean that is to get the ones in the backlog and not added to future sprints also.. 

If you want to include future sprints items in the backlog section, you can also use + or sprint in futureSprints()

Refer to functions in https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html#Advancedsearchingfunctionsreference-fsfutureSprints() 

[Richard Williams]

Following.  I'm looking to do the same.  In the Sprint Planning Board items that don't have a Sprint associated with them are found in Backlog.  (note: Backlog isn't a status in this case.) Yet, in the Advanced Filter, you can't search for <none> in the Sprint category.  Grrrr

[Pragnesh Patel]

Below query will give you all the items which are listed under Backlog 

project is '{xxxx}' and Sprint is EMPTY