SOQL Query Patterns

Common query patterns organized by use case.

Pattern Categories

• Basic Queries - Simple SELECT, filtering, sorting
• Relationship Queries - Parent/child relationships
• Aggregate Queries - COUNT, SUM, GROUP BY
• Date-Based Queries - Time-based filtering

Quick Examples

Find Records by Name

SELECT Id, Name, Industry FROM Account WHERE Name LIKE '%Acme%'

Get Related Records

SELECT Id, Name, (SELECT Id, FirstName, LastName FROM Contacts) FROM Account WHERE Id = '001xxx'

Count by Status

SELECT Status, COUNT(Id) FROM Case GROUP BY Status

Recent Records

SELECT Id, Name, CreatedDate FROM Lead WHERE CreatedDate >= LAST_N_DAYS:7 ORDER BY CreatedDate DESC

Find by Email Domain

SELECT Id, Name, Email FROM Contact WHERE Email LIKE '%@acme.com'

Records Without Related Records

SELECT Id, Name FROM Account WHERE Id NOT IN (SELECT AccountId FROM Opportunity)

Closed Won Opportunities This Quarter

SELECT Id, Name, Amount, CloseDate FROM Opportunity
WHERE IsWon = true AND CloseDate = THIS_QUARTER
ORDER BY Amount DESC

Get Record Types

SELECT Id, DeveloperName, Name FROM RecordType WHERE SObjectType = 'Opportunity'