Skip to content

Tables

The tables service allows creating, accessing and maintaining tables that can be used by applications for cross-referencing or enrichment purposes, or to store settings for example.

To see the Tables menu entry on the Portal, the tables=view permission is required.

For a summary of permission names and uses related to this service, please refer to this section.

Note

If you have the tables=* and tables=allow(*) permissions, you can have access to all the functions mentioned below.

List and view tables

To list and have access to the tables, you need to have the tables=allow(*) permission.

It is possible to restrict access to specific tables by entering the names of these tables as parameters in the allow permission:

tables=allow('Table1'(*), 'Table2'(*))
A user such a permission will only see the Table1 and Table2 tables.

It is also possible to restrict access to specific records:

tables=allow('Table1'('column1'='value1'))
A user with such a permission will have access only to the Table 1 records for which the ‘column1’ column has a value that equals ‘value1’.

Manage table records

You can browse the records of a table by double-clicking on the line associated with it.

Browse a table

Search records

You can search records using the ‘Search…’ input at the top right corner.

Edit records

After you’ve opened a table, you can add and edit records if you have the tables=edit-data permission.

Simply use your tab key to switch between input fields. Use the ‘enter’ key to submit your changes, or the ‘Save’ button on the top button bar.

Edit table data

Delete records

You can delete records if you have the tables=delete-data permission.

Import / Export records

You can export table records to an Excel spreadsheet.

You can create records by importing a file with the ‘Import’ button. Supported import files formats are CSV or Excel.
After uploading the file, a dialog window opens, with a few options to set:

Import table data

Create, edit and delete tables

Create a table

To create tables, the tables=edit-table permission is required.

The table’s structure consists of a name, a description and fields (ie: columns).

A key is a field that will be indexed and should be used for selection criteria.

Edit a table’s structure

To edit tables, the tables=edit-table permission is required.

Warning

The table’s name and the English description are mandatory and cannot be empty. You must also provide at least one key field.

Edit a table

Delete a table

This operation requires the tables=delete-table permission.

To delete a table, you can directly do it from the list with the delete icon. You can also delete multiple tables at a time by selecting them and hitting the Delete button in the top button bar.

Warning

The records are not deleted with the table.

Import/Export a table’s structure

The import and export buttons allow you to save any table structure and re-import the table in the UI. The export will create a .b2b file which you can use in a future import.

Warning

To import tables, the tables=edit-table permission is required.

Interact with tables via scripts

You can manage tables with the Scripts service using the table DSL.

Index the table

When editing a table you have access to an Index table data button. If it’s active then some modification on the indexes are required on the database.

When clicked, it will start the indexation process, deleting the previous unused indexes, and creating new ones.

Note

In any case you can force index creation by clicking the orange Force index table data button.

Warning

If there is already a job creating the indexes for that table, an error message will be displayed.