SOQL ORDER BY - 2 Fields?

Question

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.

20 seconds after posting I found the syntax is ORDER BY Field1, Field2. Accepted answer goes to first who posts a link to the documentation where this is detailed — user24634, Commented Nov 2, 2016 at 14:54
SELECT Priority , Age of Case FROM Case ORDER BY Priority ASC, Age of Case DESC ? "Multiple column sorting is supported, by listing more than one fieldExpression clause." As per documentation developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/… — Simon Govaert, Commented Nov 2, 2016 at 14:57

SF_user · Accepted Answer · 2016-11-02 14:56:21Z

28

You need to separate fields with comma like this :

ORDER BY YOURFIELD1, YOURFIELD2

answered Nov 2, 2016 at 14:56

SF_user

3,66610 gold badges44 silver badges57 bronze badges

Add a comment |

ipradhansk · Accepted Answer · 2016-11-02 14:58:23Z

10

Since Priority is type text, you could not order in a way explained. It would order alphabetically.

e.g., High -> Low -> Urgent (Alphabetically)

So, you could create one more field that is numeric and can be sorted.

Priority: 1 (Urgent), 2 (High), 3 (Low)

Then you could write SOQL like:

SELECT Priority__c, Priority_Number__c, Age__c FROM Object__c ORDER BY Priority_Number__c ASC, Age__c ASC

answered Nov 2, 2016 at 14:58

ipradhansk

2,3374 gold badges26 silver badges50 bronze badges

Thanks San. It's an ordered pick-list so in my case it works, but you make a good point! +1
– user24634
Commented Nov 2, 2016 at 14:59

Add a comment |

2 Answers 2