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.

[Varsha Joshi]

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