Operators

You can use and to build complex expressions. For example, if you wanted to see all new hires less than 3 months tenure and more than 12 months tenure:

(tenure < 3) and (tenure > 12)

or

(tenure < 3) && (tenure > 12

and and && can be used interchangeably

You can use ands and ors to build complex expressions. For example, if you wanted to see all new hires less than 3 months tenure, or any managers with less than 6 months tenure:

(tenure < 3) or (tenure < 6 and directs > 0)

The handiest operator is : (match), which partial-matches a field.

For example, to filter for all members of the Engineering team, you could use:

department:engineering or department:eng

You can enclose matched values in double-quotes, for example:

department:"human resources"

You can use commas to separate multiple values, for example:

department:"customer success",support,sales

Any result matching any of the comma-separated values will be returned.

You can specify a blank value to match null results, for example:

gender: returns people who have not specified gender

Note: When matching on a field value that is in a "string" format, any of these will work:

workAddress.country:IN

workAddress.country="IN"

workAddress.country:"IN"

Using an equals sign will not work for workAddress.country=IN because the : operator fundamentally works differently than the = operator. : is a special operator that treats anything after the : as a string-match automatically, while = can compare against anything. So if you want the = operator to treat it as a string, you have to tell it to operate that way by using the "" quotation marks, as opposed to the default assumption, which would be to looking for a field value named IN.

You can use the ! operator to negate an expression.

For example: !(department:engineering) will return everyone who is not a member of the engineering department.

You can use * to match any result, for example:

gender:* returns people who have specified any gender

The if expression will return the left side only if the right side is "truthy" (evaluates to a value that is not null, empty string, 0, or false).

This is mostly useful in aggregations. For filtering you can usually achieve the same thing with an and or or.

For example, if you wanted to return the mean base compensation only of people who have at least one direct report, you could use the aggregation:

mean{base if directs > 0}

You can specify a blank value to match null results, for example:

gender: returns people who have not specified gender

Match exactly on field values

Greater than

Less than

Greater than or equal to

Less than or equal to

Not equal to

Plus

Minus

Divide

Multiply