Overview
On this page:
To configure Dataset queries:
- Go to Datasets → Queries.
- Enter the field values as needed.
Dataset Query Configuration Properties | |
|---|---|
Column | Description |
Name | Enter a name for the query. The system allows you to know if the name is not valid. |
DB | Select the database configuration. |
SqlStatement | Enter the query using SQL syntax. You can embed tags directly on the SQL statement, embracing the tag with curtly brackets. E.g. " Alternatively, you can also update the SQLStatement with the Script Module accessing the property Dataset.Query.QueryName.SqlStatement. When doing so, if you access that property from multiple tasks, be aware of potential concurrency issues, for advanced information on that refer to the page Advanced Dataset Guide |
Mapping | Click "..." to select the tags that you want to populate with data from specific columns returned by the query. |
MappingDateTime | Select the time reference (UTC or Local). |
Description | Enter a description for the table configuration. |
Using Query Results on Scripts and Tags
Users can use query results to trigger actions in custom scripts and tags. Here are some steps for using query results in scripts and tags:
- Create a query in the Dataset module to retrieve the desired data.
- In the Scripting Module, create a custom script that references the query results.
- Use the query results to trigger specific actions within the script, such as sending notifications or updating tags.
- Save and execute the script to perform the desired actions.
Check the Stored Procedures page for additional information.
In this section...