Advanced Database Table Field (Next Gen)
The Advanced Database Table Field replaces the functionality of the Data Table custom field. It is used to retrieve data from a database or from a SIL script and display it in a table grid.
Configuring it is very similar to the Advanced Database Row Field (Configuring the Advanced Database Row Field). It comes in two variants: read-only or editable.
Read-only table field
Example:
There is only one script that needs to be configured: the DEFAULT script. For the previous example, the following SQL script was used:
SELECT id, code, name, independence, gdp_capita, capital, is_eu FROM countries ORDER BY id
Editable table field
Example:
Notice the extra icons that allow you to insert (table header), update or delete (row level) records.
The scripts that can be configured, in addition to the DEFAULT script, are: GET, INSERT, UPDATE, DELETE, SEQ. They define what is executed on the corresponding operation that is triggered to the selected row inside the table - explained in more detail here: Configuring scripts for generic fields
The general configuration options are very similar to the ones of the generic row fields: General settings for generic fields
General principles
Columns settings are described here: Columns
Any combination of SQL or SIL can be used to configure the different scripts.
The scripts are able use external parameters, in the same way they are described here: How to Use Script Parameters | External parameters.
The auto-bind feature can be activated, if you want the field to be calculated on the fly, when the dependent fields change (more auto-bind details/examples here: General settings for read-only fields | Use Auto Bind and here:More examples of Read-only Advanced Database Row Fields | Auto bind feature