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.

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.