JQL to retrieve exact backlog order

[Max Maurer]

When requesting stories in a project and ordering them by rank e.g. 

project = PROJ AND status not in (Closed, Done) order by RANK

I do get the right order for stories in the backlog. However if a sprint is active or has been prepared and contains a story with a low ranking value it will still be up top in the backlog view (showing up in the sprint) while it would be listed at the end by the above JQL.

Including the sprint in the query as  so does also only help partially:

project = PROJ AND status not in (Closed, Done) order by Sprint, RANK

Problem with this is if a story has been in sprints before (so e.g. it has been part of a sprint two sprints ago but has been taken out again) it would be sorted to the very top even if it is in the backlog.

How can I write a query that will give me the same exact order that I see from top to bottom in my Scrum Backlog view. 

[Fadoua]

@Max Maurer

Sorry a duplicate

[Fadoua]

@Max Maurer

I think the following may clarify to you how Rank works in JIRA Software. Please click here

Best,

[Max Maurer]

thanks for your answer. Problem is that the rank is not changing in case story is actually applied to a sprint. however on the scrum board it is moved up into the sprint (being on top of the backlog now). While when sorting by RANK the story is still down where it was.

[Fadoua]

@Max MaurerAre you using story points?

[Fadoua]

Also please check your board general configuration and see if you already have the filter query there @Max Maurer. Attached is a screenshot from my instance.

[Michael Green]

@Max Maurer  Did you ever get an answer to this question ?