Data Table Custom Query

Block Information

Available in: Page Flow

Toolbox Category: Widget - Data Table

Block Type: Regular

The Data Table Custom Query block allows you to use a custom Database Query for the Data Table widget.

Data Table Custom Query block

Normally the Data Table widget reads the Database Table without any match criteria or sorting rule. This block allows you to use a custom Database Query with matching criteria and/or sorting rules.

The block consists of the following (from top to bottom):


Usage Example

The image below shows an example of the Data Table Custom Query block where the Database Query named Q1 is used. A list containing two items is used as the matching criteria (via Input Params). The number of records per page is set to 10.

As previously mentioned, it's important to place a Data Table Refresh block after this one to ensure that the Data Table widget loads and presents the records. This is demonstrated in the example as well.

Example of Data Table Custom Query block

Last updated