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:
| Code Block |
|---|
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 rows(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: https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15487441/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: https://appfire.atlassian.net/wiki/spaces/PSJ/pages/540574265/General+settings+for+read-only+fields#Use-Auto-Bind and here:https://appfire.atlassian.net/wiki/spaces/PSJ/pages/559449013/More+examples+of+Read-only+Advanced+Database+Row+Fields#Auto-bind-feature
| Table of Contents |
|---|