Table records

Learn about records in data tables and how to configure them.

---

Records in a data table

Tables are the templates or definitions for holding records. When a new entity in a table is created, meaning that fields have values assigned, these entities are called records. Records are instances of a table with specific field values.

You can think of fields as the columns in a relational database or tables as documents and fields as its properties in a non-relational database. Similarly, records are the correspondant of rows in a relational database, or the values of the properties in a non-relational database.

To see and update the records of your table, go to Databases tab of your app and click Data record button.

In Data record page, you can add new records to your tables, update or delete or search them.

Adding a new record

Adding a new data to a table means inserting new records to your table.

On Data records page of your app, navigate to the table that you want to add data to and click +Add new record.

Info

You can also add a new record through Create table request.

Once you add a new record, you will see the fields of your table open up. Fill out these fields to create your record.

Updating a record

On Data records page of your app, navigate to your table and find the record you want to update and click +Edit at the right of the record.

Info

You can also update a record through Update and Update partial table requests.

Once you click Edit, you will see the fields of your table open up. Enter the fields on the opening screen to update your record.

Deleting a record

On Data records page of your app, navigate to your table and find the record you want to update and click +Delete at the right of the record.

Info

You can also delete a record through Delete table request.

Searching records

To search records in a table, navigate to your table on Data records page of your app and enter a search query.

Info

You can also search records through Search table request.

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 AND or OR.
• 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')