how to do advanced/tiered sorting?

[Sven Anderson]

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

[Sreenivasaraju P · Accepted solution]

HI @Sven Anderson,

Have you tried below query

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

[Sven Anderson]

thanks, that perfectly answers the question. I struggled around trying it with brackets  without success.

[Matthias Jupe (Scandio) · Accepted solution]

Hi Sven Anderson,

I think you mean

ORDER BY priority, created, updated

in the end of your JQL.

Greetings,

Matthias

[Sven Anderson]

thanks now it works like it should