I wanted to order a column. I know I can use DESC or ASC, but is there any other way to order. Can I give my own preference in ordering:
Eg. Order like --> Status --> First Done, Second - In Testing, Third - Rejected etc.
I am trying to match SQL query similar to this but could not. Do you have a guide or ability for this in JQL.
Your only option in JQL is to order status by DESC or ASC. There is information on using the 'ORDER BY' keyword here.
However, you can set the order of the statuses will be listed using the Statuses admin page, which can be found via Administration > Issues > Statuses. The URL to get there will be:
On this screen you can use the little arrows to change the order of the statuses:
This will change the order they show in on the search screen.
For example, if you move "Done" to the top on the Statuses admin page, it will show first on the search screen when you do JQL like:
order by status ASC
Hope this helps a bit.
If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot