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.
Thanks @Rosa Guthrie for clarifying, I know what @Nic Brough [Adaptavist] means now. Oddly, I still can't see them, neither in Chrome nor in Firefox (see below). Am I just not seeing it? I just upgraded to 7,9.2, FYI.
I have always been confused by "JIRA Server". Mine is self-hosted. Does that equate to JIRA Server?
BTW, @Rosa Guthrie, love your avatar!
@Craig Silver hahaha! thanks. I chose it because in my company I often seem to be the go-to person for "I would like..." and "I sure wish that..." and "if the system could do x...". I guess everyone thinks I am a genie that grants wishes. LOL!
Also~ see my post from Sept 19th 2017. It's a bit of a pain, but if you have a huge list of statuses like mine, you can hit the arrows 6-7 times and it will climb by that many before the screen refreshes.
@Rosa Guthrie love it! As for your suggestion from Sep 19, 2017, thanks, I missed that.
@Nic Brough [Adaptavist] Yes, I know I can use the arrows; I was just hopeful that because I have JIRA Server, latest version, the statuses would be draggable, no? You wrote, "A server install of Jira will have either arrows or the bars, depending on version." Does that mean that draggability is only on older versions?
Hello Sam Hall,
Thanks for the above answer. We have lots of projects in our JIRA self-hosted instance and the same statuses used by multiple projects/workflows. If I do the above changes for one project, will it impact to others or is there any other way to make the changes for a specific project.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs