How can you apply order by with multiple fields

Scott Milton
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 1, 2023

I want to be able to sort my issues more than one field in Jira.

As an exaple I want the results sorted by Status and then Rank

2 answers

1 accepted

3 votes
Answer accepted
Ollie Guan
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 1, 2023

Hi @Scott Milton ,

order by status, rank

Pat Schilling March 23, 2024

Works this way with just a comma delimiter between "by" clauses.   However not all field names are accepted, and some are converted, e.g. from "created" to "createdDate". or to cf[10109].   

Like Shahzad Qureshi likes this
0 votes
Peter_DevSamurai
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
November 1, 2023

!Old method!
Jira's issue search interface (JQL) does not natively support multi-level sorting, you can try.  
1. Use the Basic Issue Search: Navigate to the "Issues" section. Click on "Search for issues".

2. Choose your filter criteria: You can add other filters if needed.

3. Sort by the primary field: Click on the column header for "Status" to sort by status first. Depending on your view settings, this will sort either ascending or descending. Clicking the header again will reverse the sort order.

4. Sort by the secondary field: After you've sorted by "Status", click on the column header for "Rank" to then sort by rank. This will apply a secondary sort, meaning issues with the same status will be further sorted by rank.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events