website logo
ChartHop documentation
Carrot reference
Release notes
Navigate through spaces
ChartHop documentation
Carrot reference
Release notes
⌘K
Getting started
Getting started with Carrot
Operator precedence
Filtering with Carrot
Data categories
Basic Org Information
Compensation
Job Changes
Permissions
Personal
Recruiting
Structure
Time off
Data types
Address
Boolean
Comp
Comp Band
Currency
Date
DateTime
DaysOff
Enum
EnumList
File
Group
Image
Job
List
Money
Name
Number
Null
Percent
Person
PersonList
Shares
StockGrant
String
TimeOff
User
Operators
+ (add)
- (subtract)
* (multiply)
/ (divide)
% (modulus)
&& (and)
|| (or)
if
: (match)
= (equals)
!= (not-equals)
! (not)
> (greater-than)
>= (greater-than-equals)
< (less-than)
<= (less-than-equals)
[ ](array)
. (dot)
? (ternary)
?: (elvis)
Functions
abs()
asOf()
boolean()
compHistory()
compBetween()
costBetween()
date()
day()
daysOffBetween()
diffYears()
diffMonths()
distance()
monthEnd()
formatMoney()
formatRound()
formatNumber()
formatPercent()
formatDate()
grantedShares()
length()
max()
mean()
money()
month()
min()
nextAnniversary()
number()
pluralize()
percent()
random()
round()
roundUp()
roundDown()
string()
subString()
stockPrice()
monthStart()
split()
vestValue()
vestShares()
year()
Aggregators
count{}
max{}
mean{}
min{}
sum{}
Docs powered by archbee 
7min

: (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)
Updated 04 Nov 2021
Did this page help you?
Yes
No
UP NEXT
= (equals)
Docs powered by archbee 
TABLE OF CONTENTS
Syntax
Sample usage
Supported data types
See also