Comparison Operators
The comparison operators are used to compare values in a query.
The following comparison operators are supported:
| Operator | Description |
|---|---|
$eq | Equal. Returns true if the values are equal. |
$ne | Not equal. Returns true if the values are not equal. |
$gt | Greater than. Returns true if the first value is greater than the second. |
$gte | Greater than or equal. Returns true if the first value is greater than the second or equal. |
$lt | Less than. Returns true if the first value is less than the second. |
$lte | Less than or equal. Returns true if the first value is less than the second or equal. |
$eq​
The $eq operator is used to compare values for equality.
Syntax​
{
"$eq": [ <expression_1>, <expression_2> ]
}
Behavior​
The operator returns true if the values of the two expressions are equal.
Examples​
Object notation:
{
"&label_name": { "$eq": 10 }
}
Array notation:
{
"$eq": ["&label_name", 10]
}
$ne​
The $ne operator is used to compare values for inequality.
Syntax​
{
"$ne": [ <expression_1>, <expression_2> ]
}
Behavior​
The operator returns true if the values of the two expressions are not equal.
Examples​
Object notation:
{
"&label_name": { "$ne": 10 }
}
Array notation:
{
"$ne": ["&label_name", 10]
}
$gt​
The $gt operator is used to compare values for greater than.
Syntax​
{
"$gt": [ <expression_1>, <expression_2> ]
}
Behavior​
The operator returns true if the value of the first expression is greater than the value of the second expression.
Examples​
Object notation:
{
"&label_name": { "$gt": 10 }
}
Array notation:
{
"$gt": ["&label_name", 10]
}
$gte​
The $gte operator is used to compare values for greater than or equal.
Syntax​
{
"$gte": [ <expression_1>, <expression_2> ]
}
Behavior​
The operator returns true if the value of the first expression is greater than or equal to the value of the second expression.
Examples​
Object notation:
{
"&label_name": { "$gte": 10 }
}
Array notation:
{
"$gte": ["&label_name", 10]
}
$lt​
The $lt operator is used to compare values for less than.
Syntax​
{
"$lt": [ <expression_1>, <expression_2> ]
}
Behavior​
The operator returns true if the value of the first expression is less than the value of the second expression.
Examples​
Object notation:
{
"&label_name": { "$lt": 10 }
}
Array notation:
{
"$lt": ["&label_name", 10]
}
$lte​
The $lte operator is used to compare values for less than or equal.
Syntax​
{
"$lte": [ <expression_1>, <expression_2> ]
}
Behavior​
The operator returns true if the value of the first expression is less than or equal to the value of the second expression.
Examples​
Object notation:
{
"&label_name": { "$lte": 10 }
}
Array notation:
{
"$lte": ["&label_name", 10]
}