Sort each column oldest to newest by creation date and Done and Canceled by last modified date DESC

[Lakshmi CH]

Hi Team,

I was working on the JQL query to filter the results for the Kanban board. I want to sort each column (or bucket) from oldest to newest based on the creation date. However, for the "Done" and "Canceled" columns, I would like to sort them differently, using the last modified date in descending order.

I was trying with the board filter below, but it's showing an error. Is there anything I missed?

project = ATL AND issuetype in ("Add On", "Partial to Full") AND (statusCategory in ("To Do", "In Progress") ORDER BY created ASC) OR (statusCategory in ("Done", "Canceled") ORDER BY updated DESC)

[Trudy Claspill · Accepted solution]

Hello @Lakshmi CH 

What you want to do is not possible with native JQL.

JQL supports ORDER BY appearing only once at the end of the JQL. You can't have different ORDER BY clauses for subsets of the JQL results.

You might want to consider using a Jira Dashboard instead with multiple Filter Results gadgets. Each gadget would reference a separate filter designed to get the issues for a single "column" and order them as desired.

There also might be a third party plugin that could help you achieve your requirement. I don't know of one specifically that would do so, but you could investigate what is available in the Atlassian Marketplace. You may not be able to get what you want incorporated into the native Board view. You may have to consider a custom reporting tool that would give you the information in a different view.

[Lakshmi CH]

Understand. Thank you @Trudy Claspill for your quick response.

[Mariia Romanova _Marketplace Expert SL_]

You can try also these JQLs 

project = ATL AND issuetype in ("Add On", "Partial to Full") ORDER BY created ASC

Or if you mostly care about Done/Canceled at the top:

project = ATL AND issuetype in ("Add On", "Partial to Full") ORDER BY statusCategory DESC, updated DESC

This will:

• Sort by status category (Done → In Progress → To Do)

• Then by last updated (descending)

Hope this help a little bit ) 

[Varsha Joshi]

I had the exact same thought, that it is an invalid JQL statement. Maybe have two different boards?

[Mariia Romanova _Marketplace Expert SL_]

or probably use Sweamlines on board directly or quick filters and switch between them? But ofcourse the problem stays still - both these options will group issues by status or status category for example, and the whole board will still be sorted by a single ORDER BY clause — but you’ll at least see the issues grouped as needed.