Advanced Database Table Field

The Advanced Database Table Field is the next-generation replacement for the legacy Data Table custom field. It retrieves data from external databases or SIL scripts and presents the information in a modern table grid interface.

How to configure the Advanced Database Table Field

Advanced Database Table Field configuration follows the same process as the Advanced Database Row Field. Depending on your needs, fields can be configured as readonly or editable.

Readonly table fields: Display database information in a table format, but do not support modifications. These fields require only a DEFAULT script for data retrieval and are suitable for displaying reference data or reports where information should not be modified by users.
Editable table fields: Let you insert, update, and delete database records directly through the Jira interface. These fields require multiple scripts (GET, INSERT, UPDATE, DELETE, SEQ) to handle different operations and display action icons for data manipulation.

Contents: 1 How to configure the Advanced Database Table Field 1.1 Configuration options 2 Readonly table fields 2.1 Configuration requirements 2.2 Example configuration 3 Editable table field 3.1 Configuration requirements 3.2 Example configuration

Configuration options

Advanced Database Table Fields offer several configuration options that apply to both readonly and editable modes.

Configuration	Description

Configuration	Description
General settings	Advanced Database Table Fields share general configuration options with Advanced Database Row Fields, including data refresh settings, security configurations, and display preferences. See the General settings for generic fields page for complete details.
Column settings	Table fields offer flexible column management, including data types, constraints, and display formatting. Column settings control how data appears in the table grid and what validation rules apply to user inputs. See the Columns page for complete details.
Script flexibility	Both SQL queries and SIL scripts can be used for any script configuration, providing maximum flexibility for data operations. You can mix and match approaches based on your specific requirements - use SQL for straightforward database operations and SIL scripts for complex logic or data transformations.
External parameters	Table field scripts support external parameter integration, enabling your queries to respond dynamically to values from other Jira fields or system data. This enables contextual data display based on issue information, user selections, or other dynamic criteria. See the Script parameters page for implementation details.
Auto-bind feature	Enable auto-bind functionality to automatically refresh table data when dependent fields change. This feature ensures your table displays current, relevant information based on user selections in related fields without requiring manual refresh actions. This feature is only available for readonly table fields. For details about the Auto-bind functionality, see this section on the General settings for readonly fields page. For some Auto-bind configuration examples, review the Configuration examples for readonly Advanced Database Row fields page.

Readonly table fields

Readonly table fields display database data in a structured grid format without allowing users to modify the information directly within Jira. This mode is ideal for reference data, reports, or displaying information that should remain static within issues.

Configuration requirements

The read-only table field requires only one script configuration - the DEFAULT script. This script defines the data query that populates the table when the field loads.

Example configuration

This query retrieves country information and displays it in a table format with columns for ID, country code, name, independence date, GDP per capita, capital city, and EU membership status.

SELECT id, code, name, independence, gdp_capita, capital, is_eu FROM countries ORDER BY id

This configuration produces the following table display in Jira issues:

Editable table field

Editable table fields allow direct database modifications from within Jira issues. Users can insert, update, and delete records using action icons displayed in the table header and on individual rows.

Configuration requirements

Editable tables require multiple script configurations to handle different operations. Each script defines the database operations executed when users interact with the corresponding table functions.

Script	Description

Script	Description
DEFAULT	Populates the initial table data (same as readonly).
GET	Retrieves specific row data for editing operations.
INSERT	Handles adding new records to the database.
UPDATE	Manages modifications to existing records.
DELETE script	Processes record removal operations.
SEQ	Generates unique identifiers for new records (when needed).

For detailed script configuration guidance, see the scripts configuration page.

Example configuration

The editable table displays the same data with additional action icons for database operations: