Tables guide

This service is named tables and allows editing and visualizing cross-references tables.

To see the Tables menu entry on the Portal, you need to have the permission tables=view.

Note

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

View the tables

To read all the tables, you need to have the permission tables=allow(*), otherwise, you cannot read the data.

This permission can be adapted: you can add filters to allow only specific tables to be seen by giving the tables names as parameters in the allow permission.

For instance, if your permission has values like bellow, you will only see the records of the tables Table1 and Table2.

tables=allow('Table1'(*), 'Table2'(*))

If you want to allow a user to see the records of a table where the column column1 has the value value1, you need to give him the following permission:

tables=allow('Table1'('column1'='value1'))

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

On the table view display, you will be able to browse the opened table data. You can search some data using the search input at the top right corner.

You can also export table records to an Excel spreadsheet.

Edit a table’s structure

To edit the tables, you need to have the permission tables=edit-table.

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.

Warning

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

Delete a table

This operation requires the permission tables=delete-table.

To delete a table, you can directly do it from the tables 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.

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.

Edit a table’s records

After you’ve opened a table to browse its data, on this same user interface, if you have the required permission tables=edit-data you can add and edit table records.

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

You can also create data by importing a file with the Import button. Supported import files formats are CSV or Excel.

Delete a table’s records

Still, on the same user interface, you can delete table records if you have the following permission: tables=delete-data.