Carrot reference
Operators

: (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



Updated 19 Dec 2023
Doc contributor
Doc contributor
Did this page help you?