nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

jira_admin_cu

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)

Accepted answers

Trudy P Claspill

Hello @jira_admin_cu

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.

All comments

Trudy P Claspill

Hello @jira_admin_cu

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.

Varsha Joshi

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

jira_admin_cu

Understand. Thank you @Trudy P 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 )

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql

jira-data-center

kanban

data-center