Advanced Database Table Field (Next Gen)

Owned by Jonathan Muse
Last updated: Oct 24, 2023 by Cristian Pintea
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 (https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15487371). 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: https://appfire.atlassian.net/wiki/spaces/PSJ/pages/543031310

The general configuration options are very similar to the ones of the generic row fields: https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15482145

General principles

Columns settings are described here:

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: .

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: and here: