Table search query
Learn how to search your records in your data tables with a search query.
Actioner supports SQL like search query for the records. A query interpreted as WHERE clause of the SQL.
- If you specify more than one condition, separate the conditions by the operators
ANDorOR. JOINis not supported.
| Operators | Description | Examples |
|---|---|---|
=, !=, <, <=, >, >= | Actioner supports standart comparison operators. For the boolean fields use IS and NOT | map1.key1.key2 = 'overriding' |
AND | Used to define an intersection of two conditions. | name = 'joe' AND salary >= 1500 |
OR | Used to define a union of two conditions. | name = 'joe' OR salary >= 1500 |
IS NULL | Determines if a field has a null value. | myField IS NULL |
IS NOT NULL | Determines if a field does not have a null value. | myField IS NOT NULL |
IS TRUE | Determines if an attribute has a boolean value of true. | aFlag IS TRUE |
IS FALSE | Determines if an attribute has a boolean value of false. | aFlag IS FALSE |
IN | Determines if the value of a field is in a specified set. | hobbies IN ('gaming', 'swimming') |
NOT IN | Determines if the value of a field is not in a specified set. | hobbies NOT IN ('gaming', 'swimming') |
LIKE | Determines if a field contains a specified sub-string. The string argument for the LIKE operator accepts the percent sign (%) as a wildcard anywhere in the string. Search string cannot begin with %. | name LIKE 'jr.%' |
NOT LIKE | Determines if a field does not contain a specified sub-string. | name NOT LIKE 'jr.%' |
BETWEEN | Determines if a field between the specified values. | amount between 100 AND 2000 |
MATCH | Determines if a field matches one of the specified values. | MATCH(name, sirName) AGAINST ('joe') |