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.
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.
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.
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.
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
orOR
. 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') |