Usable Rank field values to sort the issues which are impacting customers on the high rate

[Sneha Gopinath]

Hello,

We have a swimlane on Kanban board with name 'Top priority'. If customer affected issue has priority P3 and internal defect has priority P1, we need to work on the priority P3 where customers are affected on higher rate and we need to achieve this by using rank. Rank should be provided such that the priority P3 is given higher rank than priority P1 and the issue which is impacting customers should be over the top on Kanban board. We are using a Jira version 7.3.4.

I have tried changing the board filter to order by priority, but that didn't help.

Please can someone suggest a solution.

Thanks in advance!

[John Funk]

Hi @Sneha Gopinath  - Adding ranking to boards is always tricky. First, if you change the order by on your filter from ORDER BY RANK, then you will lose the ability to manual move cards up and down the column, thereby changing the ranking. 

Second, whatever ORDER BY you add to your filter will affect the entire board, not just a single column. And, again, you wont' be able to move the cards in another column if you don't like how the filter ranked them. 

Finally, I don't understand the second part of your last question. Yes, you can change the ORDER BY in the filter to do that by Priority, but I am not sure how you are identifying "the issue which is impacting customers should be over the top on Kanban board". What do you mean by the that? And what is not working about the change you made for Priority?

[Sneha Gopinath]

Hello John,

Thank you for the reply!

Yes, the filter affects the entire board but for example if there are 2 issues :

1. One with priority P1 which is defect affecting the internal team.

2. Another with priority P3 which is impacting the customer/client on larger scale.

If Issue with priority P1 is ranked higher than the issue with priority P3, then the issue with priority P1 will be on top of the Kanban board(any column). 

But without moving cards manually to the top is there any way, where issue with priority P3(impacting the customer) can be ranked higher over another issue.  

Initially I thought if I change the board filter to sort by priority I could achieve it, but that didn't make any difference.

Appreciate your help!

[John Funk]

Priority is a standard field in Jira. Did you change the default values to be P1, P2, P3, etc.? Or did you create a new custom field with the same name?

Diid you put DESC after the order by?

ORDER BY Priority DESC

[Sneha Gopinath]

Priority field has the following values (P1, P2, P3, P4, Low,  Blocker, Critical, High, Medium, Major, Minor, Must be Fixed, Highest, Undefined, Show stopper). I am using the default priority field and have not created another field.

Yes, I tried ORDER BY Priority DESC. But, order by priority sorts the issues with priority in descending order.

'P1' is given a higher priority than 'P3' between 'P1' and 'P3' . So, ordering by priority DESC will have issue with P1 (which is an issue affecting internal team) on top of the Kanban board.

But, we need to have issue with priority 'P3'(which is an issue affecting customer/client) to be displayed on Top of the Board. Can we achieve this with Order by Rank?

[John Funk]

It sounds like you need to create a custom field and just put in the values that you want to sort on. Then add that to your filter. 

You can use an add-on like Automation For Jira or ScriptRunner to automatically populate/change the custom field value when the Priority field is populated/changed. 

[Sneha Gopinath]

Hello John,

We have Adaptive ScriptRunner add on. Please can you help us with the script to be written to automatically populate/change the custom field value when the Priority field is populated.

That would be a great help!