O'Reilly logo

Development with the Force.com Platform: Building Business Applications in the Cloud, Third Edition by Jason Ouellette

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required