Development questions
How do INCLUDES and EXCLUDES operators work when querying Multi-Select Picklist fields in SOQL?
Multi-select picklist values are stored as a semicolon-separated string. Use INCLUDES and EXCLUDES rather than = / LIKE.
INCLUDES ('A;B', 'C')= (A and B) or C. Semicolon means AND within an option, comma means OR between options.EXCLUDES ('A')= records that do not have A selected.
soql
SELECT Id FROM Candidate__c WHERE Skills__c INCLUDES ('Apex;LWC', 'Java')
soqlmulti-select-picklist
More Development questions
- What is an Apex Trigger in Salesforce and when should you use it over Flows?
- What is the difference between before triggers and after triggers?
- Explain all Trigger context variables (isInsert, isUpdate, isDelete, isUndelete, isBefore, isAfter, isExecuting, size, operationType).
- What is the difference between Trigger.new and Trigger.old?
- In which trigger events are Trigger.new and Trigger.newMap available?
- In which trigger events are Trigger.old and Trigger.oldMap available?