Carrot reference
Operators
: (match)
Returns true where the value of a given field and a given expression partially match.
expression: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.
- Anything after the : must be a `String`. To compare two fields to each other, or to perform an exact comparison, use the = (equals) operator.