---
title: "Advanced Database Table Field"
canonical: "https://support.appfire.com/space/PSJ/15485796/Advanced%20Database%20Table%20Field"
format: markdown
---
> Macro (aura-html)
### Configuration options
Advanced Database Table Fields offer several configuration options that apply to both readonly and editable modes.
| **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](https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15482145) 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](https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15481863) 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](https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15487441/How+to+use+script+parameters#External-parameters) 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](https://appfire.atlassian.net/wiki/spaces/PSJ/pages/540574265) on the [General settings for readonly fields](https://appfire.atlassian.net/wiki/spaces/PSJ/pages/540574265) page.
> ℹ️ - For some Auto-bind configuration examples, review the [Configuration examples for readonly Advanced Database Row fields](https://appfire.atlassian.net/wiki/spaces/PSJ/pages/559449013/Configuration+examples+for+read-only+Advanced+Database+Row+fields#Auto-bind-feature) 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** |
| --- | --- |
| **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](https://appfire.atlassian.net/wiki/spaces/PSJ/pages/543031310).
### Example configuration
The editable table displays the same data with additional action icons for database operations:
