Can you order Issues by a specific ticket number order for the purpose of priorityisation

[Greg Clayton]

Hi All

I have a list of Issues that all have a priority 1-40 for example but not using a label etc as if new issue comes in then all labels have to change. So I would like to know if there is a jql statement I can use that allows me to display the Issues on screen in a set order. Hope that makes sense. 

Thanks in advance

Greg

[Trudy Claspill]

Hello @Greg Clayton 

Welcome to the Atlassian community.

JQL has an ORDER BY clause. With that you specify the field that you want to use for ordering the issues, and whether you want the order to be descending or ascending. You can only specify fields that Jira is natively capable of determining how to order the content.

I am not clear in your example what field you are wanting to use for ordering, so I am unable to say if what you want to do is possible.

Can you give an example of the values in the field and how you would want to order the issues based on those values?

[Greg Clayton]

Hi, I have a list of Issues each obviously with their own key id, I would like to list them in a specific order based on how I would like to prioritise them. A colleague advised you used to be able to use the ORDER BY and were able to list the exact order to list the issues in (SUP-123, SUP-156, SUP-132, SUP-152). I hope that makes sense.

Thanks and appreciate any help.

[John Funk]

Hi Greg - Welcome to the Atlassian Community!

What field exactly would you want to order by?

[Greg Clayton]

Hi, it would be the Key field. I have a list of Issues each obviously with their own key id, I would like to list them in a specific order based on how I would like to prioritise them. A colleague advised you used to be able to use the ORDER BY and were able to list the exact order to list the issues in (SUP-123, SUP-156, SUP-132, SUP-152). I hope that makes sense.

I am aiming for a list that I can display in priority order so I can just shift the key line up or down based on priority (highest at top to lowest at bottom). This will allow me to allocate the issue at the top to the next developer knowing it is the highest priority that has been set by me.

Thanks and appreciate any help.

[Walter Buggenhout]

Hi @Greg Clayton and welcome to the Community!

This set order in Jira is known as Rank. It is a built-in ordering system (based on Lexorank if I am not mistaken) that remembers how issues are ordered relative to each other. An issue's rank can be updated e.g. by dragging them above one another in a scrum or kanban board. The complexity of updating all these order labels is handled automatically by the system.

If you want to sort issues by Jira's ranking system, e.g. in a particular project, you can create a JQL filter like this:

Project = ABC ORDER BY Rank ASC

(or ORDER BY Rank DESC to reverse the sort order).

You can order issues by any other field in exactly the same way as with rank in JQL, but as you rightfully mentioned, that does not resolve the issue that every modification of a single issues rank potentially impacts any other issue in your system. So using the built-in ranking system is definitely worth the recommendation.

Hope this helps!

[Greg Clayton]

Hi, I have a list of Issues each obviously with their own key id, I would like to list them in a specific order based on how I would like to prioritise them. A colleague advised you used to be able to use the ORDER BY Key and were able to list the exact order to list the issues in (SUP-123, SUP-156, SUP-132, SUP-152). I hope that makes sense.

I am aiming for a list that I can display in priority order so I can just shift the key line up or down based on priority (highest at top to lowest at bottom). This will allow me to allocate the issue at the top to the next developer knowing it is the highest priority that has been set by me.

Thanks and appreciate any help.