Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

query all issues in backlog

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

But I cannot find the right query.

3 answers

1 accepted

0 votes
Answer accepted
John Funk Community Leader May 28, 2021

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

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

Like # people like this
John Funk Community Leader Jan 13, 2022

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

Like Dave Rosenlund _Tempo_ likes this
b_gupta I'm New Here Feb 22, 2023

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

John Funk Community Leader Feb 22, 2023

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. 

Try this...

Project = 'ABC' and Sprint is EMPTY

@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,

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

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.

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

4 votes

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 

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

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

project is '{xxxx}' and Sprint is EMPTY

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events