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!

[Ashley]

I'm not sure why @Alexander Christian was having issues. Perhaps it was a bug that they indeed fixed. 

@Tigly Migly 

When I sort the statuses in Settings → System → Issue Attributes/Statuses:

I've found that this ordering is being respected in queues, on columns in widget dashboards, and when using JQL ORDER BY ASC/DESC.

[fev]

I think this answers yuor question for statuses: https://community.atlassian.com/t5/Jira-questions/How-do-I-change-the-order-of-the-workflow-status-in-the-dropdown/qaq-p/585605

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

[Alexander Christian]

@Dave Mathijs 
I cannot confirm this. Its sorted by something else, but not alphanumeric or alphabetical.

proof:

How can it be, that when sorting by status, a status beginning with "P" is between two other status beginning with "V"?!

I also don't understand why I can set an order in:

Jira Settings -> Issues -> Issue Attributes -> Statuses


Here I have set the correct order of my statuses:

But it looks like this order is used nowhere...

Can you shed some light on this and explain?

Right now, this looks like a bug to me ...

best regards,
Alex


P.S. using Jira Professional Cloud.

[Mike Rubin]

+1 to this question / request