Why do items in a current sprint show below some backlog items when working with rank

Question

Hope you can help.

I want to create a simple query to show a priotitised list of items that have the same component. I though I had done this but it appears to prioritise some items at the top of the backlog ahead of items in the current sprint.

The top 12 are at the top of the backlog THEN it shows one of the items at the top of the current sprint then some more backlog items then another from the sprint. Shouldn't any sprint items by definiton have a higher priority (Rank)than a backlog item?

Any thoughts?

Query

project = blah AND component = "Web user interface" AND status != Done AND issuetype != Sub-task ORDER BY RANK

Ben Clark_abyhmu · Answer

Thanks for the answer. I don't think this will help. The general query is related to the Rank of the items.

My expectation was that items already in an active sprint would have a higher RANK than items in the backlog. When you view the sprint it is above the backlog and therefore you would expect items in the sprint to have a higher rank.

I'm seeing this when using rank to sort. With Backlog items seemingly having a higher Rank than items in the backlog.

Rank Order in Query
Backlog item 1
Backlog item 2
Backlog item 3
Backlog item 4
Backlog item 5
Backlog item 6
Backlog item 7
Backlog item 8
Backlog item 9
Backlog item 10
Backlog item 11
Backlog item 12
Sprint Item 1
Backlog item 13
Backlog item 14
Backlog item 15
Backlog item 16
Backlog item 17
Backlog item 18
Backlog item 19
Sprint Item 2

etc

Andrew_g4chs4 · Answer

Hi @Ben Clark ,

Not sure I correct understand question, but maybe You need double sorting?

For exqample:

issuetype = Story ORDER BY "Epic Link", priority

B.R.