Overview
The Dataset Tables section in the Dataset module simplifies data table management. Customize structure, relationships, and data types effortlessly through an intuitive interface. This streamlines data handling and promotes efficient data management.
On this page:
Tables
Table configuration properties in the Dataset module allow users to tailor their database tables for optimal data management. Key fields include:
Dataset Table Configuration Properties | |
---|---|
Field / Column | Description |
Name | Enter a name for the table configuration. The system lets you know if the name is not valid. |
DB | Select the database connection. |
TableName | Select or type the table name in the Database you want to access |
WhereCondition | Specify the parameters that will filter the data using SQL syntax. E.g. " |
Access | Select the access permissions for the table. |
Mapping | Click "..." to select the tags that you want to populate with data in the first row of the table with data from specific columns. |
MappingDateTime | Select the time reference (UTC or Local). |
Description | Enter a description for the table configuration. |
In this section...