Table search query

Learn how to search your records in your tables with a search query.

---

How to use search queries

You can use queries to find the records you're looking for in your tables.

• You can enter your search query on Records page of your tables.

• You can them in Query field of Search records action.

Search query syntax reference

Actioner supports search query for the records in your table.

• If you specify more than one condition, separate the conditions by AND or OR operators.
• JOIN is 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')