ORDER BY

For more details check Check SOQL API - ORDER BY.

NOTE! 🚨 All examples use inline queries built with the SOQL Lib Query Builder. If you are using a selector, replace SOQL.of(...) with YourSelectorName.query().

Control the order of the query results.

SObjectField Field

SOQL

SELECT Id
FROM Account
ORDER BY Name DESC

SOQL Lib

SOQL.of(Account.SObjectType)
    .orderBy(Account.Name)
    .sortDesc()
    .toList();

String Field

SOQL

SELECT Id
FROM Account
ORDER BY Name DESC

SOQL Lib

SOQL.of(Account.SObjectType)
    .orderBy('Name')
    .sortDesc()
    .toList();

Related Field

SOQL

SELECT Id
FROM Contact
ORDER BY Account.Name

SOQL Lib

SOQL.of(Contact.SObjectType)
    .orderBy('Account', Account.Name)
    .toList();

Multiple Fields

SELECT Id
FROM Account
ORDER BY CreatedDate DESC, Name DESC NULLS LAST

SOQL Lib

SOQL.of(Account.SObjectType)
    .orderBy(Account.CreatedDate)
    .sortDesc()
    .orderBy(Account.Name)
    .sortDesc()
    .nullsLast()
    .toList();