SOQL and SOSL Cheat Sheet

Reference & Cheat SheetsSOQL and SOSL Cheat SheetA complete quick reference for Salesforce query languages: SOQL syntax, operators, every date literal and date function, aggregates with ROLLUP/CUBE, relationship and polymorphic queries, semi/anti-join rules, security clauses, dynamic SOQL with binds, SOSL, common errors, and 45+ ready-to-use queries for setup, security and monitoring.Intermediate · about 50 minutesWhat you will learn

Write any SOQL clause in the correct order, including WITH, GROUP BY ROLLUP/CUBE, FOR UPDATE and SET OPTIONS

Use date literals, date functions, convertTimezone(), FORMAT(), toLabel() and convertCurrency() correctly

Write parent-to-child, child-to-parent, polymorphic (TYPEOF) and semi/anti-join queries within the documented rules

Choose between WITH USER_MODE, WITH SYSTEM_MODE and the legacy WITH SECURITY_ENFORCED, and know the API 67.0 behaviour change

Build safe dynamic SOQL with Database.queryWithBinds and write SOSL searches

Reuse ready-made queries for permissions, sharing, async jobs, code coverage and org metadata

Contents

SOQL syntax skeleton

Operators

Date literals (complete)

Date functions

Formatting and translation functions

Aggregate functions

Relationship queries

Semi-joins and anti-joins

FIELDS()

Security clauses and access modes

Locking and tracking: FOR UPDATE, FOR VIEW, FOR REFERENCE

LIMIT, OFFSET and pagination

Dynamic SOQL and binds

SOSL syntax and examples

Selectivity quick reference

Common errors and fixes

Ready-to-use queries

Data 360 queries (SET OPTIONS)

Best practices

Hands-on exercises

Key takeaways