To activate this tab, select the process value type SQL Value, in the tab called "Process value". Here you will enter an SQL query and that query will then determine which data will be collected. It will also determine which connection string will be used as well as what connection the data source will use. Here is more information on how SQL queries work.
It is important to know that the SQL query will collect its value from the first row and that first row's first value. When you configure the SQL query you should do that so that it will never return an empty value, which in this case is called a NULL value, which will result in empty rows and an erroneous value as well.
SQL Query
In this
field, you enter the SQL query. To create a valid query, it is important that you
make sure that the question always returns a row with a column.
Data
source
Here you
choose which data source the SQL query should use, right now there are two
options available.
- Balthzar: If you use this option the SQL query will be
asked towards Balthzars database.
- ODBC: If you use this option the SQL
query will be asked towards an ODBC with the correct type of connection string.
Connection string
If the data source is of an ODBC type you have
to enter the correct type of connection string here.