Versions Compared

Old Version 3

changes.mady.by.user user-05e19

Saved on

compared with

New Version 4

changes.mady.by.user user-05e19

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview


On this page:

Table of Contents
maxLevel3

To configure Dataset queries:

  1. Go to Datasets → Queries.
  2. 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. "ColumnName = {tag.tagInt}"

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.

Showing DataGrids Tables on Displays

One of the key features of the Dataset module is the ability to display query results on screens and dashboards using visualization tools like DataGrids. Here are some steps for using DataGrids to display query results:

  1. Create a query in the Dataset module to retrieve the desired data.
  2. In the Displays Module, add a DataGrid control to the screen or dashboard.
  3. Configure the DataGrid to display the query results by selecting the data source and column mappings.
  4. Save and preview the screen or dashboard to display the query results on the DataGrid.

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:

  1. Create a query in the Dataset module to retrieve the desired data.
  2. In the Scripting Module, create a custom script that references the query results.
  3. Use the query results to trigger specific actions within the script, such as sending notifications or updating tags.
  4. Save and execute the script to perform the desired actions.

Check the Stored Procedures page for additional information.

In this section...

Page Tree
root@parent
spacesV10