Query examples
- Last UpdatedAug 18, 2025
- 1 minute read
- PI System
- Adapter for RDBMS 1.1
- Adapters
[
{
"QueryId": "Tank1",
"QueryString": "SELECT TEMPERATURE, PRESSURE, VOLUME, SAMPLETIME FROM TANK1 WHERE SAMPLETIME > ?LST? ORDER BY SAMPLETIME ASC"
},
{
"QueryId": "Tanks",
"QueryString": "SELECT ASSET, TEMPERATURE, PRESSURE, VOLUME, SAMPLETIME FROM TANK1 WHERE SAMPLETIME > ?LST? ORDER BY SAMPLETIME ASC"
}
]
Stored procedures
The adapter allows for stored procedures to be called from a query. For example:
[
{
"QueryId": "Tank1",
"QueryString": "EXECUTE Tank1PROC ?LST?, ?ET?;"
}
]
CREATE PROCEDURE Tank1PROC
@LST DateTime,
@ET DateTime
AS
SET NOCOUNT ON;
TEMPERATURE, PRESSURE, VOLUME, SAMPLETIME FROM TANK1 WHERE SAMPLETIME >= @LST AND SAMPLETIME <= @ET ORDER BY SAMPLETIME ASC;
GO