I’m looking for a way to achieve this in SOQL:
I’d like to order by the Priority field on Case, otherwise order by Age of Case
So for example:
Priority - Age of Case Urgent , 5 Urgent , 4 High , 7 High , 6 Low , 17 Low , 10 Low , 5
Hope this makes sense.
You need to separate fields with comma like this :
ORDER BY YOURFIELD1, YOURFIELD2
See the documentation :