The Data Table Block displays a list of rows from one of your application data tables.
Configuring the Data Table Block is broken up over three sections …
First, choose one of your application’s data tables from which rows should be returned.
Optionally, you may include a data table query to only return a subset of your table’s rows.
The “Property” and “Value” fields for each section of the query support string templates resolving to values in your dashboard context. When building a query in Advanced Mode, the field supports JSON templates.
After selecting a data table you will be able to select which columns should be displayed and the order in which they should appear. By default, the block will display all available columns.
You can remove a column by clicking the remove icon on the right side of the panel, but note that all values per data table row will be included in the data response even if they are not being displayed.
If any columns have been removed or are missing from the current configuration, they can be added by clicking the Add Column button and selecting a column from the menu. Columns can be reordered by clicking and dragging the column panels. Columns that are at the top of the column configuration will appear in order from left to right inside the block.
After choosing a table, from the configuration screen, you may use the sort arrows in the block preview’s table header to set the default sort column and direction.
Dashboard users can choose different sort options by clicking these arrows on the dashboard, but every time they leave the page and return to it, the block will reset to its default sort order.