Order JQL Result by status order

Question

Hello

Is there a way to make JQL "ORDER BY status" really order the items in a desired sequence?

Depending on the workflow, sometimes I want to order (for example) Backlog, Open, In Progress, In Review; and sometimes I want to see the order as Backlog, Open, In Review, In Progress

By default, it seems that the 'order by status" uses the rank of statuses from the complete list of statuses in the admin pages. However we have here around 60 statuses used in many workflows by many people, and I cannot specify a complete ordering.

I have seen people using "opsbar-sequence" as a property on the workflow transition. But this seems not to work on JQL queries (for example in a filter)

Any other idea?

This seems to me a trivial need. Why not just sequence numbers in every workflow?
Thank you
Vincent

Aron Gombas _Midori_ · Answer

It would be rather unfriendly, but in theory, if you renamed your statuses to "1 - Done", "2 - Rejected", "3 - On hold", etc. (or used another set of alphabetically ordered prefixes), it would work.

I don't know about other workarounds. Not even with apps, because although apps can provide additional JQL functions, they cannot provide additional ORDER BY clause extensions...

Meurice Frank · Answer

I have a similair ask 
Is it possible to change the "order by status" from ASC to [Done, Rejected, On hold, In progress, Committed, Analyse, backlog] ?

As you see, not alfabetical. Would be great to have this filter by array kind of functionality instead of as suggested to make a custom field "RANK" which needs to be created and applied.

Aron Gombas _Midori_ · Answer

Workaround idea:

* You add a number type custom field "Status Rank"
* You implement an automation rule which initializes / updates the "Status Rank" field based on the "Status" field (it is effectively a lookup like "Backlog" -> "1", "Open" -> "2", and so on)

Then in JQL:

project = FOO order by "Status Rank"