I'm trying to sort data in the issue navigator based on minimum three fields, just using column headers and not via Advanced Search.
If I click on the column headers one by one, the order I do that (sorting) gets changed.
Click on the headers you want in the reverse order.
ie if you want headers A then B then C
click on
C then B then A.
Simples
I believe this can be done with JQL only. Switch to the Advanced view and you'll see your query's JQL. Modify or add ORDER BY clause as described in the JQL documentation - e.g. "order by created, priority desc"
Thanks and I understand that this works. But one of our clients is very particular that they don't want to use the Advanced search option.
Tried this on a trial and error basis: Switch to Advanced searching, tried clicking on the headers of various columns.
My requirement was to order the results by reporter first, then by assignee and finally 'Due date'. If I click on the headers in this sequence my JQL Query shows 'ORDER BY due DESC, assignee ASC, reporter ASC'; So, I do my sequence just opposite to my requirement and it works. Not sure whether there is any other way to do my sorting - Sort by A, then by B and finally by C.
Use this
ORDER BY due DESC, assignee ASC, reporter ASC
Hi @Maysarah Abu-Laban
What if I want different statuses to have different order on one board, this one did not work in filter:
ORDER BY status ("DONE", "In Progress") ASC, status ("TODO", "Released") DESC
what is wrong here?
Thank you a lot!
It looks like you're new here. Sign in or register to get started.