$and
) is used to combine conditions.name
and emails
) are queried.Each attribute type has specific properties available, so the set of possible filters varies by attribute type.
$eq
- Equality$eq
is usually implied but can also be specified explicitly.
Deals with an exact name
$not_empty
Companies which have at least one domain
$in
Records where record_id
is one of many values
$contains
Name contains John
$not_contains
Name does not contains John
$starts_with
& $ends_with
People with phone numbers starting +1
Phone number starts with+1
and ends with0909
$lt
: Less than$lte
: Less than or equal$gte
: Greater than or equal$gt
: Greater thanPeople with 4 or more rating
people created in 2024
$and
, $or
, and $not
.
$and
Operator$and
is implied.
People with name John Doe and email is john@doe.com
$or
OperatorList all peoples with name John Doe or Alice Doe
$not
OperatorPeople not with name John