BookatlasTwo-Day MuleSoft → Salesforce Bootcamp
78 / 278 · Module 5 — Salesforce Data Model + SOQL · filtered: code← prev⊞ allnext →

5.13WHERE conditions

You'll recognize:

WHERE Status__c = 'Active'

Multiple conditions:

WHERE Status__c = 'Active'
AND BillingState = 'FL'

OR:

WHERE Industry = 'Technology'
OR Industry = 'Healthcare'

I recommend using parentheses when logic gets more complicated:

WHERE Status__c = 'Active'
AND (
    BillingState = 'FL'
    OR BillingState = 'GA'
)

Same reason you would in normal SQL: readability.