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

[Alexey Matveev · Accepted solution]

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.