How to order tickets by status in filter

Question

Hi

I encontered tricky situation - ordering by status is organised by workflow status creation date, not by type.

I did created workflow and after modified it by customer request with additional in-progress type steps. Now, when I order the tickets by status the last added steps are shown as last, not Done type status. (see screenshot)
Is there any other way to organise filter results by status?

Thanks for the advise

Toomas Adson

Hannes Obweger - JXL for Jira · Answer

... and just to expand on my last point:

I acknowledge that this problem, in itself, may not justify additional tooling, but just to put it out there: If you're open to solutions from the Atlassian Marketplace, sorting by status would work as expected in the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you'd do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Plus, it sorts statuses first by status category (i.e., "gray" before "blue" before "green"), and second using a smart combination of alphabetical and numeric sorting, meaning that your statuses would be sorted like e.g. so:

Any questions just let me know,

Best,

Hannes

Hannes Obweger - JXL for Jira · Answer

Hi @Toomas Adson

JQL is sorting statuses based on their order in

Jira Administration > Issues > Statuses

where higher in this list means higher in the JQL result with ASC sorting order.

Mind having a look if changing this order would be an option for you?

(On a site note, in Cloud, you could also use an ORDER BY statusCategory clause in JQL, but I believe that this isn't available in Server/Data Center.)

Alternatively, if you're open to solutions from the Atlassian Marketplace, you'll have more options available. I'll add more information below.

Hope this helps,

Best,

Hannes