How to order tickets by status in filter

Toomas Adson
Contributor
November 12, 2024

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 

 

Order by status.JPG

 

Toomas Adson

1 answer

0 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
November 13, 2024

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

Hannes Obweger - JXL for Jira
Atlassian Partner
November 13, 2024

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

sort-by-status.gif

Any questions just let me know,

Best,

Hannes

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events