Apex Intermediate Progress | ( Lessons)

Lesson: 07 | ORDER BY

Notes
Video

Notes

You can specify the order in which search results are returned from a SOSL query using the ORDER BY clause. You can also use the clause to display empty records at the beginning or end of the results.

Use one or more ORDER BY clauses in a SOSL statement.

FIND {Hotel} IN ALL FIELDS RETURNING Account(Name ORDER BY Name ASC )

FIND {MyContactName} RETURNING Contact(Name, Id ORDER BY Name), Account(Description, Id ORDER BY Description)

This search returns account records in descending alphabetical order by name, with accounts that have null names appearing last.

Nulls First
Nulls Last

FIND {Bank} IN NAME FIELDS RETURNING Account(Name, Id ORDER BY Name DESC NULLS last)

Prev You need to login to have access to the quizzes. Next

Mastered by 36 users.

Apex Intermediate

A. Apex DML Operations (8 lessons)

B. Apex Classes (17 lessons)

C. Apex Triggers (9 lessons)

D. Apex Exceptions (11 lessons)

E. Asynchronous Apex (6 lessons)

F. SOSL (10 lessons)

G. Testing Apex (9 lessons)

H. Apex Fast Recap (142 lessons)

I. Build Apex Coding Skills (64 lessons)

J. Miscellaneous (17 lessons)

You need to complete all the quizzes before certification.

Go to top

Login to your account

Lesson: 07 | ORDER BY

Notes

Apex Intermediate