Overview
The Dataset Tables section in the Dataset module simplifies data table management. Customize structure, relationships, and data types effortlessly through an intuitive interface 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 .
- Click Ok.
| Info |
|---|
The use of spaces is not allowed in the Name. Instead, use underscores. For example: My_Table |
To edit a Dataset Table, 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 managementon the data grid. The table below describes each available property column.
Column | Description |
|---|---|
Name | Enter a name for the table configurationThe Table's name inside the plataform solution. |
DB | Select Defines the database connectionconnected to the Table. |
Table Name | Select or type the table The Table's name in the Database you want to access. |
Where Condition | Specify the parameters that will filter the data using SQL syntax. For example: " |
Access | Select Defines the access permissions for the table. |
Mapping | Click the button with three dots (...) to select the tags that you want to populate with data in the first row of the table with data from specific columns. |
Mapping Date Time | Select Specify the time reference (UTC or Local). |
Description | Enter a description for the table configurationTable's description. |
In this section...
| Page Tree | ||||
|---|---|---|---|---|
|