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!
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As I already said, try "order by <what you want to order by>". Order by Satus asc/desc, order by colour asc/desc, etc.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"Order by" looks at how the option list is organised now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Nic Brough I agree with @Ed Maschler - we can Order by status (asc) but that puts the gadget in alphabetical order rather than in the order of the workflow making it harder to read. Do we have to ensure our workflow is in alphabetical order or pre-fixed with a number to make this easier?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It's the same answer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi - new to Jira so apologies if this is a daft question - how can i order filter output to come by their hierarchy, so i see a parent and all its child tickets together ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Welcome to the Atlassian Community!
Not daft at all. It's something Jira does not yet do well, but I've been fixing it for over decade by scripting a (read-only, but sortable) field that appears on all issues and their sub-tasks. It contains <parent issue key> for the parent, and <parent issue key> / <sub-task issue key> Sorting on that string groups all of them together.
(I really should look at writing that in Scriptrunner for Cloud)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I read through this thread as I have the same request about customizing the sort order for a field vs using ASC or DESC. Was that question answered and is there a way to do that currently with a JQL query?
Example of what I'm hoping for:
project = <project name> and status not in (closed, canceled) order by component (customized order of the components)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am sorry, but Jira doesn't do the (customized order of the components) bit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the quick response, @Nic Brough -Adaptavist-! Is there a process to request this as a potential future feature?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
But that is just predefined asc or dsc. I want to be able to give a custom order list
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Welcome to the Atlassian Community!
This cannot be done - you cannot sort on elements in your query, you can only sort by fields.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Nic Brough , 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?"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It's usually "issue type"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.