JQL: is it possible to sort status by Status category

[Tatiana Marti]

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

[Stephen Wright _Elabor8_ · Accepted solution]

Hi @Tatiana Marti 

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

[Tatiana Marti]

hello,

It was very painful to classify the 68 statuses manually and one by one but it works

Thanks a lot

Tania

[Asha]

Hi @Tatiana Marti

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 

[Hannes Obweger - JXL for Jira]

@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.

[Bill Sheboy]

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

[Stephen Wright _Elabor8_]

To be clear, I tried it on Server - it doesn't work.

Ste

[Hannes Obweger - JXL for Jira]

Yep, confirmed; thx @Stephen Wright _Elabor8_. TIL.