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

Next challenges

Recent achievements


  • Give kudos
  • My kudos


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do I filter on all issues that are on the board of a project in advanced filters?

In advanced filters, one of the criteria I want to use is whether an issue is on the board or in the backlog. How do I do that?

2 answers

1 accepted

0 votes
Answer accepted
Warren Community Leader Jul 01, 2019

Hi @Alexander Wegener 

+1 for @Ilya Turov 's answer if you are using a Scrum board. If you're using Kanban you would need another way.

Could you base the query on the status? Certainly for Kanban, you may well have a status that is reserved for the backog (often called Backlog). If you go to Board settings and choose Columns, you can see which statuses appear on the Active board and which don't

We are using a Kanban board. Where do I find the board settings?

The status available in the filter are "Done" "In Progress" "To Do"

Warren Community Leader Jul 01, 2019

You don't mention whether you're using cloud or server Jira, but I think both are similar (I have cloud, so my description is based on that).

You will need to be an Admin of the project. Click on the three dots in the top right hand corner and Board settings is the first option.


You can see from the screenshot below that we have an explicit status for the Backlog - if you don't, this would probably not work. You could create another status and make it the "backlog" one


If I am on the board and I click the 3 dots, this is what I get.

This is a next-gen project - might this be the problem?

ScreenShot 898 OT board - Agile board - JIRA - Google Chrome.png

Warren Community Leader Jul 01, 2019

Hi @Alexander Wegener 

Yes, that's the issue. Next-gen Kanban boards don't seem to be able to differentiate between items in the backlog and those on the board. I can't see any way around this, unless if you create a new field which you manually set as something goes on the board (which is far from ideal)

Like Alexander Wegener likes this

Thank you! At least now I know.

I guess, if issue is still in the backlog, it's not in any sprint, so looking for something like "sprint is EMPTY" might be a start. 

There are also functions like "sprint in openSprints()", "sprint in futureSprints()" or "sprint in closedSprints()"

For more discussion on it you can look at some past topics.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,642 views 22 33
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you