Skip to main content
Version: 2024 R1

Data table

The form field is used to display values from a data source in a table. In addition, it is possible to display links in the table columns.

Examples of the link display configuration:

  • after returning the value as link:<link> e.g. link:http://www.webcon.com a link that redirects to www.webcon.com is displayed,
  • the displayname parameter sets the searched name, e.g. the value link:http://www.webcon.com;displayname:WEBCON displays the name WEBCON redirecting to www.webcon.com,
  • adding the target:_self results in opening a link in the same window, e.g. link:http://www.webcon.com;target:_self;displayname: WEBCON,
  • it is possible to execute a JavaScript script e.g. link:http://www.webcon.com;target:_self;onclick:alert("Dialogue has been executed"),
  • you can open different links in the same window, e.g. the following links are opened in the same window:
    link:javascript:window.open ("http://www.webcon.com","mywindow");void(0);target:_self;displayname:WEBCON
    link:javascript:window.open ("http://blog.webcon.pl", "mywindow");void(0);target:_self;displayname:WEBCON Blog.

Advanced configuration

The window offers advanced configuration options for the Data table form field.

SelectGrid.png

1. Query data source if variables return empty values

When checked, the system permits variables that return empty values. If the checkbox is unselected and the tag used in the query in the data source or the form field returns empty value, the records in the form field on the editable form are not displayed.

2. Show form field name

Displays the form field name specified in the General tab.

3. Show form field description

Displays the form field description (checked by default).

4. Show columns names

Column headers display the Display name defined individually for each respective column (if the Display name column is empty, the column name returned by the query is displayed).

5. Show summary row

Allows the summary row to be displayed for individual columns. This row may either display the sum of values or their average. Click the Aggregation Type field for the desired column to define which mode is to be used.

6. Load on demand

When checked, the Data table will not be loaded by default. It will be loaded only after clicking the button next to it.
If this option is enabled and a dependent field's value is changed, the Table will only reload if it previously had data.

7. Allow Excel export

The checkbox permits the export of the form field content to an Excel file.

caution

For performance reasons, only a maximum of 1,000 rows can be exported to an Excel spreadsheet.

info

To learn more about exporting the Data table content, read the ARTICLE available in the WEBCON Community website.

8. Allow sorting data

When checked, the content of the Data table is sorted.

9. Paging

The checkbox allows you to specify whether the query results are to be displayed on multiple pages.

10. Page size

The field allows you to specify the number of results displayed per page.

Example

./img/drex_Sql_grid_custom.png