The Dataset Tables section in the Dataset module simplifies data table management. Customize structure, relationships, and data types through an intuitive interface that streamlines data handling and promotes efficient data management.
On this page:
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.
- Click Ok.
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 on the data grid. The table below describes each available property.
Column | Description |
|---|---|
Name | The Table's name inside the plataform solution. |
DB | Defines the database connected to the Table. |
Table Name | The Table's name in the Database you want to access. |
WhereCondition | Specify the parameters that will filter the data using SQL syntax. For example: " |
Access | 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. |
MappingDateTime | Specify how the time in Database will be interpreted (UTC or Local), when mapping to DateTimeOffset .NET variables. |
Description | Table's description. |
In this section: