Query parameters
- Last UpdatedAug 18, 2025
- 1 minute read
- PI System
- Adapter for RDBMS 1.1
- Adapters
The following parameters are available to configure queries to be sent to the Open Database Connectivity (ODBC) driver. The supported query syntax depends on the ODBC driver you are using. These queries are sent to the driver exactly as defined, and the adapter uses the driver response to collect data.
Refer to the documentation for your ODBC driver for supported query syntax.
|
Parameter |
Required |
Type |
Description |
|---|---|---|---|
|
queryString |
Required |
string |
The SQL query to run. |
|
id |
Required |
string |
String identifier of the query to be referenced by data selection items. |
Within queryString, you can use the placeholder values listed below to streamline query configuration. Delimit the placeholders with question marks. Placeholders include:
-
?LST?: Last Scan Time
This timestamp represents the time the adapter ran the last scan.
-
?ET?: End Time.
If the adapter is in history recovery mode, this will be the ?ST? value plus the requestInterval specified in the data source configuration. For example, if requestInterval is set to 1 hour, there will be an hour difference between ?ST? and ?ET?. If the adapter is not in history recovery mode, this is replaced with the current time.
-
?ST?: Start Time.
If the adapter is in history recovery mode, this placeholder is replaced by the StartTime specified in the history recovery configuration on the first scan. After the first scan during history recovery, this placeholder is replaced by the timestamp of the last event collected.