Page History

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.