Returns true where the value of a given field and a given expression partially match.
- Single-word Strings do not require quotations.
- Multi-word Strings require quotations: field:"multi-word string".
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.
- = (equals)
- != (not-equals)
- ! (not)
Updated 03 May 2023
Did this page help you?