rank and priority sorting

Jira Median December 8, 2017

Hi,

The backlog is ordered by default by rank and we have the rank functionnality to have the drag n drop functionnality.

But is it possible to sort by rank ASC and by priority DESC and have the drag n drop functionnality ?

because when we add the priority sorting we don't have anymore the drag n drop.

 

thanks

7 answers

1 accepted

4 votes
Answer accepted
Ignacio Pulgar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 8, 2017

Ordering by Rank ASC is a requirement for the drag&drop to work; no workarounds for that.

The best you can do is reordering them manually, possibly by taking advantage of multiple selection capability > mouse right click > send to top/bottom.

Matthew Jevne
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 16, 2018

Technically not solved.  No solution isn't a solution :)

Like # people like this
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 16, 2018

There's a reason the flag is called "accepted".

Also, there is no "solution" - if you want to rank a list, you have to use a rank.

lukas.bohrmann
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 30, 2018

I understand that there is no solution for ranking and also ordering by priority inside of one sprint. But if I prefer to order my sprints by priority, why am I not allowed to use the right-click and move from one sprint to another. I see no contradiction.

Like # people like this
Caleb Collins-Parks
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 14, 2019

I would love to see automatic rank/priority ordering implemented as a feature.

Like # people like this
heather johnpillai August 14, 2019

Given I'm a user vs. an admin, I would like to have a mechanism in JQL to be able to determine the order of values within a field.  Let me know if there is a way that I've not found.

Thanks!

Like # people like this
Jj Cv
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 12, 2020

It doesn't sound intuitive...if i filter by name and description I would expect a sorted list by name and in case of same name a second sort by description...

I think similar pattern should apply when sorting by rank ASC and by priority DESC, 

First sort by rank and when the rank is the same sort by priority...therefore the first time i apply the rank filter all elements should have same rank(since i have not drag&drop any element yet) and a second sort should apply based on the next order by criteria...no?

Al Capone
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 18, 2020

I think there could be added feature to rank items around the same priority level only. For example lets have 3 items of high priority - currently Jira decides about the order while I sort with priority. Would be great if I could change the rank of the 3 items because I want the last one on the list to be done first.

To summarize I would have items ordered automatically by different priorities and ranked inside of each priority lvl. Of course ranking items between different priorities could be restricted.

Like # people like this
Ben Hill
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 10, 2024

@Al Capone I agree with you! I wish we could do:

ORDER BY priority DECS, rank ASC 

so that cards with the same priority could be manually moved around.

Like Jeroen van Disseldorp likes this
3 votes
Markus_COGNITIFF June 15, 2020

I interpret the meaning of “rank” more broadly. The decision to assign an issue specific rank is typically based on some underlying business rule. For example, issue X ranks higher than Y because it has more customer value (or takes less time to implement). The execution of that decision in the default Jira implementation is manual – users arrange issues in the desired order using drag-and-drop, and the resulting ranking is stored in the rank system field.

I think the inconvenience that people mentioned arises in situations where the data that feeds into the ranking decision already exists in Jira, like Priority or Story Points. So, for example, ranking all issues in a backlog by Story Points in descending order requires moving issues up and down by hand, even if each has a story point value. Understandably, it can get frustrating.

One way to accomplish the above sort order is to add Priority (or Story Points) to the ‘order by’ clause of the board query. But as Nic says, since issues are no longer sorted by rank but by Priority directly, drag and drop stops working. It is logical if you think about it – drag-and-drop cannot change the priority or the story points of an issue.

Another way is to use a plugin that works with the rank field. The plugin will update the rank based on a rule that you define. You can have a look at Sort by any Field plugin our company (COGNITIFF) developed for this purpose, since we were facing the same issue.

Ignacio Pulgar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 16, 2020

Cool solution! Upvoted!

By the way, it would also be great if it supported a given calculation, like Value / Story Points, or something like that.

Promising app. Will test it soon!

Regards

1 vote
ChalkyNZ May 18, 2022

Yeah I’ve found myself wanting both, but if you had both, and a new issue is created, how would it be sorted?

Also if you’re only ranking within same priority, can have a board with swimlanes priority but ordered by rank.

1 vote
John Worrall August 3, 2020

I teach my product owners to use rank to determine the order in which they want things worked on, which is not always the same as priority.

Something may be a high priority ask, but may not be urgent.  Something could be a low priority, but easy to deal with, and the person who knows how to do it best may be going on vacation next week, etc etc, and you put it at the top of the list so that they see it, even if the work itself is not a burning hot priority.

Priority in Jira is a terrific way to quickly see how important a ticket is, and if you want to, you can run queries to see how well your team handles A-level, B-level, etc... but in terms of actually managing your workflow, Rank determines where people will see the ticket in a list, and to me, that's what matters more (unless for some reason I'm filtering a list by priority, which I try to avoid doing, because it ignores rank).

I hope this makes sense to folks.

0 votes
Mikaela Bertucci June 1, 2020

Ok so I just made a work around. 

 

I created false sprints for each of my rankings. 

 

Must Have, 

Should Have

Could Have

Won't have 

 

Then I ran a filter with order by priority asc .. which then sorted my backlog quickly. Then selected all of the Must Have's right clicked and added them to the false sprint Must Have. 

And then I did the same for Should Have, Could Have and Won't Have. 

Then changed the backlog filter back to order by rank asc

So now the false sprints act like group by

0 votes
Mikaela Bertucci June 1, 2020

Shouldn't this be a simple query.. group by priority and then order by rank????????????????

JQL doesn't allow group by.. how come??????????

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 1, 2020

That can't work because you couldn't then rank the issues.

There's no "group by" because JQL is a search for issues, it has nothing to say about what you report the list on.

Elisabeta Kozak October 25, 2023

This should be simpler than that:

ORDER BY priority DESC, Rank ASC

would allow ordering by priority and within the same priority to drag and drop (and update the rank)

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 29, 2023

I'm afraid that won't work - for ranking to work, you need to be able to rank across priorities.  Ranking and prioritisation are not the same thing.

Elisabeta Kozak October 30, 2023

For when you need to Rank across priorities, you have the current setting

ORDER BY Rank ASC

What I was proposing was for ranking within a priority :)

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 30, 2023

But it won't work, because ranking and prioritisation are not the same thing.

Elisabeta Kozak May 20, 2024

It would, the result for ORDER BY priority DESC, Rank ASC would look like:

  • Priority 1 - Rank 1
  • Priority 1 - Rank 2
  • Priority 1 - Rank 3
  • Priority 2 - Rank 1
  • Priority 2 - Rank 2
  • Priority 2 - Rank 3
  • Priority 3 - Rank 1
  • Priority 3 - Rank 2
  • Priority 3 - Rank 3

Maybe this clarifies a bit what we are aiming for :)

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 23, 2024

That cannot work - to rank an issue, by definition, it has to be a unique placement in the list.

And, again, ranking and prioritisation are not the same thing.

0 votes
Deleted user September 24, 2018

Not really user friendly as the whole concept of the backlog is implementation according to priority. Is the status still the same? 

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 24, 2018

Yes, it has not changed, and it won't change either.  The concept of a backlog implementation is that you put your issues in order, which you can't do with priority, you have to do it with a rank.

Deleted user September 24, 2018

Thanks, can you help a bit on to use ranking? Is it just the manual order that you put your self in the dashboard backlog, when I add the field it look more like a code than a usable thing for user. 

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 24, 2018

Yes, it's the order you put things in on the backlog.  The field it is in is not really human readable, don't bother putting it on screens.

Like DeNae Leverentz likes this
Deleted user September 24, 2018

Thank you so much

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events