Status custom sorting - order by?

[Tigly Migly]

Hi,

I have a filter with the list of the issues, I want to sort them by statuses so that: 

'In progress' is first, 

'Open' is next,

rest of the issues (closed, implemented etc).

Any standard way how to right jql 'order by' for this?

Is there any jql standard functions alike (if then else), decode, or (case when then end)?

Thanks!

[Dave Mathijs]

Hi @Tigly Migly welcome to the Atlassian Community!

ORDER BY is only ASC or DESC, you cannot define a non-alphabetical order.

[Tigly Migly]

Dave, thank you for the swift response!

ugh, you broke my heart. 

[Radek Dostál]

Closest to that would probably be a combination,

ORDER BY resolved, status

which should give unresolved issues on top, resolved on bottom, sorted by status through the first "section" (open, in progress). The resolved section will probably not be sorted by status at all since resolved should be distinct values, but at least something a little closer overall.

[Dave Mathijs]

@Tigly Migly  Although my answer is - understandably - not the one you expected, thanks to click the green Accept answer button if it answered your question.