Where can I find a complete list of all ORDER BY options?

[Steven Robinson]

I am having trouble locating a full list of ORDER BY options... when I use the Issue Navigator it shows the first 10 or so options and then indicates there are ~465 other options but I can't scroll through them.  So, I need to type a keyword in order to see if it exists.  Is there a comprehensive list somewhere?  When I tried google searches I couldn't get past finding syntax related questions.  I have no idea how to narrow my search.  If anyone can point me to a comprehensive list of sort options (with descriptions of what they do would be a plus as well).

Thanks!

[Nic Brough -Adaptavist- · Accepted solution]

There's no direct "comprehensive list" because the list is variable and unique to each instance.  The short answer is "Order by <any of your fields>"

The technical rule  for the list is "Any field that uses a searcher that provides ordering".

The longer version is that the list is made up of

• System fields
• Aliases for system fields (due and due date for example)
• Fields provided by Applications such as Software or Service Desk
• All custom fields (that have been given a searcher that supports ordering - by default, they all are, but I mention it because you may have someone who wanted a field that can't be searched or sorted, and hence removed the searcher for it)

[Ed Maschler]

Is there a way to specify the order, not just ASC or DESC?
For instance:  I want to do it by Statuses.  Our Statuses follow a certain order based on the workflow.  When I run the report, I would like NOT to have to rearrange the output because the Status names in alpha order do not match the workflow

[Nic Brough -Adaptavist-]

As I already said, try "order by <what you want to order by>".  Order by Satus asc/desc, order by colour asc/desc, etc.

[Ed Maschler]

Nic, please re-read my question. It is not a simple asc or desc. its being able to make it sort by a specified order like: (To Do, Ready for Dev, In Progress, In PR, In Review Dev Env, Ready to Merge to QA Environment, Ready for QA, QA in Progress, Ready for UAT, QA in Progress, UAT Complete, Done)

[Nic Brough -Adaptavist-]

I understood your question the first time.  As I aleady said, try "order by <what you want to order by>".  Order by Satus asc/desc, order by colour asc/desc, etc.

[Meg Fletcher]

Hi, I'm very new to Jira but interested in custom sorting.

For example I have priorities ie. blocker, major, normal, minor.

BUT.  the order by DESC goes blocker, major, minor, normal.  (alphabetical)

Is it possible to customize the priority? this is the current filter used ORDER BY priority DESC

thanks

[Nic Brough -Adaptavist-]

"Order by" looks at how the option list is organised now.

[Olga Videc · Accepted solution]

Hello @Steven Robinson 

There is no "strict" list on this but you can order by any field or custom field.

From Atlassian documentation

"Used to specify the fields by whose values the search results will be sorted.

By default, the field's own sorting order will be used. You can override this by specifying ascending order ("asc") or descending order ("desc")."

Order by  documentation.

BR, Olga