IN expression that checks if a property matches any value in a list.
Tests whether a property's value equals any value in an array of possible values.
This is more efficient than using multiple OR expressions when checking against
multiple possible values.
Equivalent to SQL's WHERE property IN (value1, value2, value3) or multiple
OR conditions like property = value1 OR property = value2 OR property = value3.
IN expression that checks if a property matches any value in a list.
Tests whether a property's value equals any value in an array of possible values. This is more efficient than using multiple OR expressions when checking against multiple possible values.
Equivalent to SQL's
WHERE property IN (value1, value2, value3)or multiple OR conditions likeproperty = value1 OR property = value2 OR property = value3.Example: Find deals in multiple status values
Example: Find companies in specific cities
Example: Find objects with specific IDs
Example: Combine with AND, active deals owned by specific users
See