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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use this
ORDER BY due DESC, assignee ASC, reporter ASC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
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.
Hi! This does not work for the case of:
as I get the error about ranking
Has anyone else had the same?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use this
ORDER BY due DESC, assignee ASC, reporter ASC
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.