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

what filter query will list all items in backlog in the same ranking order from top to bottom?

I have tried various queries with the filter 


project in (PIN) order by rank asc"

but it doesn't produce exactly the same order top to bottom in the backlog tab.

it seems like there are other things affecting the order?

2 answers

1. this is the current order of backlog top to bottom

backlog order.png

2. this is the order using a filter with the only sort  "... order by rank asc"

backlog order filter.png


3. I am at a loss why it is doing this. the items supposed to be at top are near the bottom.

while items that have not yet been assigned to sprint mostly showing up top

0 votes
Mark Segall Community Leader May 18, 2022

Hi @Great Ancheta - I just ran a query that orders by rank and it seems to return results accurately.  One thing to note is that epic ranking will be a little muddled because, while they're ranked against each other, they're ranked independently of stories/tasks so, if your query is returning all issue types epics will be scattered throughout your results.  Also, Sub-tasks will be displayed just after their parent issues.

The sub-tasks with their parents is because sub-tasks do not have a global rank themselves, they are part of their parent issue.

Like Mark Segall likes this

Thanks for the reply. oh sorry made a new answer as a response to your answer. if you can check it.

Mark Segall Community Leader May 18, 2022

Your query is not filtering out resolved issues so those will show on top.  If you want an accurate reflection of your current backlog, you should probably do something like this:

project = PIN AND issueType != Epic AND resolved IS EMPTY ORDER BY rank
Like Great Ancheta likes this

I tried that query and this is the result. it removed some items but still not same as backlog. 110, 120 , 148 not at top

backlog order filter 3.png

Mark Segall Community Leader May 18, 2022

I'm not sure that ranking changes just because an issue is moved into a sprint.  You may need to create two filters and then combine.  Something like this:

Filter 1: Sprint Query

project = PIN AND sprint in opensprints() ORDER BY Rank ASC

Filter 2: Backlog Query

project = PIN AND sprint NOT IN opensprints() AND issueType !=Epic and resolved IS EMPTY ORDER BY Rank ASC

Filter 3: Putting it all together

Filter In ("Filter 1", "Filter 2")

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

162 views 0 4
Join discussion

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