Overview
The Dataset Tables section in the Dataset module Module simplifies data table management. Customize structure, relationships, and data types through an intuitive interface that streamlines data handling and promotes efficient data management.
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.
| 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 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. |
Where ConditionWhereCondition | 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. |
Mapping Date TimeMappingDateTime | Specify how the time reference in Database will be interpreted (UTC or Local), when mapping to DateTimeOffset .NET variables, or to Tags in the application using the Mapping column. |
Description | Table's description. |
Datasets Table Columns
DatasetTable Properties | |
|---|---|
ID | Identifies the unique identifier for the DatasetTable. |
VersionID | Shows the specific version number of the DatasetTable. |
Name | Names the DatasetTable configuration for identification and reference. |
DB | Specifies the database to which the table configuration connects. |
TableName | Defines the name of the database table being accessed or modified. |
WhereCondition | Sets the conditions that filter or limit the rows affected by the operation. |
Access | Specifies the access level required to interact with the table configuration. Read: Grants permission to view or retrieve data from the table. Users can select and read rows based on specified conditions but cannot modify, insert, or delete any data. Insert: Allows users to add new rows to the table. Users can insert data into the table but cannot update, delete, or read existing rows. ReadWrite: Provides full access to the table, allowing users to read, insert, update, and delete data. This option enables complete interaction with the table, covering all CRUD (Create, Read, Update, Delete) operations. Unrestricted: Removes all access limitations, allowing users to perform any action on the table, including reading, inserting, updating, deleting, and even altering the table's structure if necessary. |
Mapping | Links the operation's input or output to tag values or variables. |
DateTimeMode | Specifies how date and time values are handled in the table configuration. Include Local and UTC options. |
Level | Classifies the table configuration within a specific level or hierarchy. |
Category | Groups the table configuration within a specific category for organization. |
LockState | Indicates whether the table configuration is locked and cannot be modified. |
LockOwner | Identifies the owner responsible for locking the table configuration. |
DateCreated | Records the date and time when the table configuration was created. |
DateModified | Records the date and time when the table configuration was last modified. |
Description | Summarizes the purpose and details of the table configuration. |
In this section:
In this section...| Page Tree | ||||
|---|---|---|---|---|
|