Free Query

This type of query requires more user experience of the SQL language and the database it is connecting to. The user will have to manually configure the Query to return the desired columns to configure the field Key, Value, Timestamp and Quality.

To configure a Free Query, follow the steps below:

1. Configure the Connection String, Timeout Field, Retry Interval and Action fields.

2. Create a new Query.

3. Configure the field Query with a desired SQL statement. For example, insert a simple "SELECT * FROM" statement or insert a desired procedure.

4. Configure the field Update Command with a desired SQL statement. For example, insert a simple "UPDATE table SET" statement or insert a desired procedure.

Note: This field is not required depending of the flow of the data configured in the Actions Field

5. Configure the Key Field (required), Value Field (required) associated with the desired column of the selected table

6. Configure the Timestamp Field (not required)

7. Configure the Quality Field (not required)

. Query

. Update Command