INCLUDES keyword in SOQL

INCLUDES keyword is used as filter for multi-select picklist in Salesforce.



Sample Query:

SELECT Name, AccountNumber, Territories__c FROM Account Where Territories__c INCLUDES ('North','South','')

here North, South and '' are values. '' mean null values(Territories Covered field is not filled).

Output:


1 comment:

  1. Great article, it was very helpful! I just started in this and I'm getting to know it better! Cheers, keep up the good work!

    PIC Scheme Singapore

    ReplyDelete