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 that streamlines data handling and promotes efficient data management.
On this page:
| Table of Contents | ||
|---|---|---|
|
Tables
To create and configure a Database Table follow these steps:
- Access Datasets → Tables.
- Click the plus icon.
Enter a Name and Description for the table, and click Ok.
Info The use of spaces is not allowed in the Name. Instead, use underscores. For example: My_Table
- In the list of Dataset Tables, double-click the property you wish to edit on the row corresponding to the table you want to modify.
Table configuration properties in the Dataset module allow users to tailor their database tables for optimal data management. Key fields include:The table below describes each property column.
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. |
TableNameTable Name | Select or type the table name in the Database you want to access |
WhereConditionWhere Condition | Specify the parameters that will filter the data using SQL syntax. E.g. For example: " |
Access | Select the access permissions for the table. |
Mapping | Click "the button with three dots (..." to ) to select the tags that you want to populate with data in the first row of the table with data from specific columns. |
MappingDateTimeMapping Date Time | Select the time reference (UTC or Local). |
Description | Enter a description for the table configuration. |
In this section...
| Page Tree | ||||
|---|---|---|---|---|
|