Multi-Select Picklists
Multi-select picklists are interchangeable with ordinary picklists in queries, except for being prohibited in the ORDER BY clause. SOQL includes two additional features for filtering multi-select picklists, described in the following list:
Semicolon AND operator—The semicolon is used to express multiple string literals. For example, 'Java;Apex' means that the multi-select picklist has both Java and Apex items selected in any order. The semicolon notation can be used with the = and != SOQL operators to make assertions about the selected items of multi-select picklists.
INCLUDES and EXCLUDES keywords—The INCLUDES and EXCLUDES ...
Get Development with the Force.com Platform: Building Business Applications in the Cloud, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
