How to Order by Rank and Priority

JD Lobue

I want to order by rank and then by priority. All my readings points me to this can't be done. I'm confused as to why?

ORDER BY Rank ASC, priority DESC

This would allow cards to be able to be dragged on the column up and down based on rank and also would set a default so that any highest priority items be set to the top.

Can anyone tell me why this can't be done?

Nic Brough -Adaptavist-

As John and Jonas mention, your "order by rank" will make the priority sort completely redundant.  It is not as simple as this and doesn't work this way in the background, but you can think of the rank being a unique value.  Unlike priority, you will never have two or more issues with the same rank.  So if your first sort is "by rank", no other sort is ever going to make any difference.

Consider:

• ABC-123, rank = 1fdsfs, priority low
• ABC-127, rank = 2dsfs, priority medium
• ABC-132, rank = 3fdsfs, priority medium
• ABC-234, rank = 4fdsfs, priority high
• ABC-745, rank = 5fdsfs, priority low

Your sort is always going to come out in that order, because the ranks are in that order and are unique.  A secondary sort does nothing, because for each rank you have, there is only one issue to sort.

You say "if a highest priority item comes to us from support, it shows up on our board at the top"

That's fine, but the way to do that is not by sorting, because sorting by priority means you are no longer ranking and hence can't re-rank stuff.  You shouldn't be pushing things to the top of your backlog just because someone outside the team sets a field really, that's something the team (including the product owner) should decide to do and hence Jira doesn't really have anything that would do it - it's built to support the team deciding there may be an exception to their ranking, not accept other people forcing it on them.

If your process really is that though, you could go find an app that can re-rank issues automatically (Automation can't do this, from what I've seen) and set it up so that "if issue created has priority = X, rank it at the top of the backlog"