This service is named
tables and allows editing and visualizing cross-references tables.
To see the menu entry Tables on the Portal, you need to have the permission
If you have the permissions
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.
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:
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
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.
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
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: