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 …
Choosing a Data Table
First, choose one of your application’s data tables from which rows should be returned.
Building a Query
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.
Selecting and Ordering Columns
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.
The Custom column provides access to all available data table information to be displayed in a completely custom way. It defaults to displaying the full
row object, which holds all data table row properties.
Above is an example of a custom column that uses the subtraction Handlebars helper to calculate profit from revenue and cost columns.
Setting Default Sort Order
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.