Skip to main content

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.

View data records

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.

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.

Adding new 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.

Edit a 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.

Editing a 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.

Delete a 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.

Search records

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.
OperatorsDescriptionExamples
=, !=, <, <=, >, >=Actioner supports standart comparison operators. For the boolean fields use IS and NOTmap1.key1.key2 = 'overriding'
ANDUsed to define an intersection of two conditions.name = 'joe' AND salary >= 1500
ORUsed to define a union of two conditions.name = 'joe' OR salary >= 1500
IS NULLDetermines if a field has a null value.myField IS NULL
IS NOT NULLDetermines if a field does not have a null value.myField IS NOT NULL
IS TRUEDetermines if an attribute has a boolean value of true.aFlag IS TRUE
IS FALSEDetermines if an attribute has a boolean value of false.aFlag IS FALSE
INDetermines if the value of a field is in a specified set.hobbies IN ('gaming', 'swimming')
NOT INDetermines if the value of a field is not in a specified set.hobbies NOT IN ('gaming', 'swimming')
LIKEDetermines 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 LIKEDetermines if a field does not contain a specified sub-string.name NOT LIKE 'jr.%'
BETWEENDetermines if a field between the specified values.amount between 100 AND 2000
MATCHDetermines if a field matches one of the specified values.MATCH(name, sirName) AGAINST ('joe')