|
Note: This is advanced topic |
Any conditions built using the standard operator are converted to an expression tree which is queried against the sandbox database. For even greater flexibility, SQLite language constructs can be used.
To use SQL, simple use the following operator:
Operator |
Description and usage |
$sql |
The expression to evaluate. It should return True or False. |
An example of a filter would be:
[...]
"conditions": [
{
"$and": [
{
"PrimaryUser": { "$ne": "DGFF" }
},
{
"$sql": "DeviceManufacturer LIKE '%HPE%'"
}
]
}
]
[...]
This condition checks if both PrimaryUser is not equal to DGFF (standard operator) AND that the value of column DeviceManufacturer contains HPE. Also note that you can freely combine built-in expression with SQL expression as we did in this example.