how to do advanced/tiered sorting?

Question

Hey all,

is there a possibility to create a tiered search statements in the issue collector like:

1st tier: is priority descending
2nd tier: creation date descending
3rd tier: last Update ascending

I have played with the JQL statements but with no sufficient outcome since it runs into errors when trying to integrate a 2nd tier.

Any suggestion?

Thanks in advance,

Sven

Matthias Jupe (Scandio) · Accepted Answer

Hi Sven Anderson,

I think you mean

ORDER BY priority, created, updated

in the end of your JQL.

Greetings,

Matthias

Sreenivasaraju P · Accepted Answer

HI @Sven Anderson,

Have you tried below query

project = "project name" ORDER BY  priority DESC, created DESC,updated ASC