Advanced Database Table Field (Next Gen)

Owned by Jonathan Muse
Last updated: Nov 19, 2024
2 min read

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