"Order by" does not appear to be working for me

[Andrew Yoward]

I have a queue which holds all the unassigned open tickets.  I want to be able to order this by highest priority, oldest ticket as the one that then appears at the top of the list should be the one that is taken next.  However, I don't appear to be able to do that.  It will order either by priority OR by date, but not both.

Here is my JQL, can anyone see what I'm doing wrong?

resolution = Unresolved AND assignee is EMPTY AND status != Closed AND status != Resolved AND status != Declined ORDER BY createdDate ASC, Priority DESC

This is the outcome of that JQL

If I change the order to ORDER BY Priority DESC, createdDate ASC I get this

[Jack Brickey · Accepted solution]

I can’t easily observe your images as I am on my phone.

A couple of things to try...

use order by issuekey desc, priority desc

paste your query into the Advanced search and observe results

[Andrew Yoward]

Using issuekey seems to have cracked it!!

I used ORDER BY Priority DESC, issuekey ASC and that seems to work.

Thank you.

[Andrew Yoward]

This is the result when you have ORDER BY Priority DESC, createdDate ASC

[Andrew Yoward]

This is the result when you have ORDER BY createdDate ASC, Priority DESC