You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Hello,
In certain JQL searches, we would like an order by status category, or even, if possible, by order of workflow status.
Do you know if this is possible?
Thanks a lot.
Tania
It's not possible to order by status category unfortunately.
You can order by Status order though - the order is based on the order of Statuses within your system (i.e Jira Administration > Issues > Statuses)
ASC is classed as top > bottom of list.
Ste
hello,
It was very painful to classify the 68 statuses manually and one by one but it works
Thanks a lot
Tania
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Status category values can be used in JQL queries and formulas.You can create a custom JQL search using Status or Status Category for use in Reports and filters.
You can use below query for status category
project= "XYZ" AND statusCategory = Done
The order by will first order by statuscategory, then if two issues have the same statuscategory, Jira will order by status.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Tatiana Marti (cc @Stephen Wright _Elabor8_),
perhaps I'm missing something, but wouldn't
ORDER BY statusCategory
do exactly that?
EDIT: This appears to be supported in Jira Cloud only.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Hannes Obweger - JXL for Jira
I am using Jira Cloud, and that worked for me also. But Tatiana appears to be using Jira Server: did you try it with that version? Thanks!
Kind regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To be clear, I tried it on Server - it doesn't work.
Ste
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yep, confirmed; thx @Stephen Wright _Elabor8_. TIL.
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.