|
<< Click to Display Table of Contents >> ETL > 12.6 > Implementation Guide > Tutorial and implementation guide > Steps > Filtering Comparison and other operators |
The following operators are supported:
Operator |
Description and usage |
$gt |
The value is greater than |
$gte |
The value is greater or equal than |
$lt |
The value is less than |
$lte |
The value is less or equal than |
$ne |
The value is not equal to |
$eq |
The value is equal than |
$contains |
The value contains a string |
$startsWith |
The value starts with |
$endsWith |
The value ends with |
The syntax for defining this operators is also shared with Mongo. You define the name of the column as a key, the value is another object with your operator, and its value is the value you want to use. A few examples with explanation:
Name is not equal to Marcin:
{
"Name":
{
"$ne": "Marcin"
}
}
Age is greater than 17
{
"Age":
{
"$gt": 17
}
}
CompanyName contains Raynet
{
"CompanyName":
{
"$contains": "Raynet"
}
}
CompanyName does not contain Raynet (negation of contains)
{
"CompanyName":
{
"$not":
{
"$contains": "Raynet"
}
}
}