The above comparison operators, as well as the MATCH and MATCHES operators described below in the Full Text Search Queries section, should only be applied to scalar properties. There is another set of queries that may be applied to arrays or collections of scalar values, for example, properties of type int[], or Set of Strings. Use the INCLUDES, INCLUDES ANY, or INCLUDES ALL operators only for querying multi-valued properties.

The INCLUDES query matches items for whom the specified property includes the specified value. For example:

interests INCLUDES "biking"

The INCLUDES query can also match one of a set of items. To do this, the ANY or ALL keyword must be used, and the comma-separated set of items must be enclosed in braces. For example:

interests INCLUDES ANY { "biking", "swimming" }

This is equivalent to:

(interests INCLUDES "biking") OR (interests INCLUDES "swimming")

While this:

interests INCLUDES ALL { "biking", "swimming" }

is equivalent to:

(interests INCLUDES "biking") AND (interests INCLUDES "swimming")
 
loading table of contents...