nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Steven Robinson_prq2mn

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!

Accepted answers

Nic Brough -Adaptavist-

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)

Olga Videc

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

All comments

Nic Brough -Adaptavist-

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)

Olga Videc

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

Ed Maschler_y5a6dk

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_y5a6dk

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)

Ed Maschler_y5a6dk

But that is just predefined asc or dsc. I want to be able to give a custom order list

Issam Helewa

Same here I want to explicitly order types verus asc, desc since the output would make sense when review from a list.

ORDER BY Type {Epic, Feature, "User Story", Task}

NOT

ORDER BY Type desc

Francisco Soto_t4myh5

I'm using this JQL on the search:

key in (asd-1, asd-5, ddd-108, asd-4, ddd-42)

I want to see the result of the search in that same order. How can I do this?

ps: note that I'm looking at two different projects ASD and DDD

Thanks!

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

This cannot be done - you cannot sort on elements in your query, you can only sort by fields.

Matt Loughran_otu7r3

@[deleted], like @Issam Helewa I would also like order by Type but I don't see a Type option when I enter it into the Order By list. Can you speak to this? Is "Type" not a "field?"

Nic Brough -Adaptavist-

It's usually "issue type"

Stephen Ellwood

The native ordering in Jira sucks. For instance it cannot do alpha-numeric or even simply numeric sorting.

One plug-in that does offer some additional features is Jira Snapshots for Confluence. It allows you to do a layered search. For instance you can search for all the epics in a project and then search for the issues in each of those epics. You can have many levels and you choose which items to display from each layer so you can get quite nice ordered reports.

For the record I do not work for RadBee, I am just an enthusiastic user of their Plugin. Its a relatively expensive Plugin but we need it for baselining as its the only tool that seems to do it properly.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

atl-gruland