JQL oldest ticket and highest priority

Question

Hello Community,

I need a JQL for a JSM cloud project with the below requirement, sort tickets in the following order :

Incidents->Service requests -> the oldest ticket and highest priority.

Suppose we have 3 tickets, with 2 Incidents and 1 service request. We would like to see Incidents first and then service requests.

In those 2 Incidents, if the priority is P2 for both, we would like to see the oldest P2 Incidents first.

Jack Brickey · Accepted Answer

hi @WasimBuden ,

try this...

project = xxxxx AND "Ticket category" in (incidents, "service requests") ORDER BY issuetype ASC, priority DESC, created ASC