: (match)

Returns true where the value of a given field and a given expression partially match.

Syntax

expression:match

• Single-word Strings do not require quotations.
• Multi-word Strings require quotations: field:"multi-word string".

Sample usage

department:engineering returns all records where department contains the string engineering.

department:eng returns all records where department contains the string `eng`.

department:engineering,sales,"customer success" returns all records where department matches any of engineering, sales, customer success.

department:* returns all records where department has any value.

department: returns all records where department has no value.

Supported data types

• Anything after the : must be a `String`. To compare two fields to each other, or to perform an exact comparison, use the = (equals) operator.

See also

• = (equals)
• != (not-equals)
• ! (not)