November 1, 2012

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).


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