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; } } }

JQL query sorting using keyword?

Tizzle Dexter

We have a fairly complex jql query we are trying to run in our jira system, we have multiple what ifs, Exclusions etc, the filter itself is working great,however sorting it I am running into trouble. Is there a way to sort by a keyword say (*) to appear at top of the list, then sort all tickets without the keyword by the creation date

Accepted answers

Alexey Matveev

Hello,

To sort tickets you should use the ORDER BY close. For example, to sort issue by the creation date, you would write a JQL like this:

project = PROJECT order by created

All comments

Alexey Matveev

Hello,

To sort tickets you should use the ORDER BY close. For example, to sort issue by the creation date, you would write a JQL like this:

project = PROJECT order by created

Tizzle Dexter

Thanks, my apologies if i was a bit unclear, it was pretty late when i wrote my original question.

What i am looking to do is a multiple tiered sorting. I want to have all tickets with a keyword appear first, then all other tickets in the same project appear by the created date. Is that a possibility?

I am thinking no and i will need to set priorities instead of keyword and sort by priority/created date?

Alexey Matveev

You would need to create custom field, which would return the order of an issue and then sort by this field.

You can create such custom fields with plugins like Power Custom Fields Premium or ScriptRunner.

Tizzle Dexter

Thanks very much, i will look into that.

Welcome!

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

Quick Links

Find more posts tagged with

jira