Historian Connector Query Types
Each Historian Connector Type supports a set of allowed Query Types:
OSIsoft PI Connector
OSIsoft PI Web API is used to retrieve data from the historian. The following query types are supported:
- GetValuesAdHoc: Returns values of the specified tags. This will retrieve the value for a tag according to how the Step attribute has been configured. Using Stepped=1 will ensure that the latest available value for a tag is returned.
- GetRecordedAdHoc: Returns recorded values of the specified tags.
- GetInterpolatedAdHoc: Returns interpolated values of the specified tags over the specified time range at the specified sampling interval.
- GetSummariesAdHoc: Returns summary values of the specified tags.
The type of query is set automatically and is shown in the Query Type column.
IP21 Connector
IP21 Connectors support the following Query Types:
- >CurrentValue
- Raw
- TWAvg
- Min
- Max
- Sample-Interpolated
- Sample-Stepped
- nearestGoodDataPointBeforeATime
- nearestGoodDataPointAfterATime
- nearestGoodDataPointBeforeATimeFixedTS
- nearestGoodDataPointAfterATimeFixedTS
- WellData
By default all query types except WellData are retrieved using the IP21 "WS_TagDataAdvanced" function. This can be changed in the "ip21-adaptor-cred" credentials file.
The WellData Query Type is retrieved using the IP21 "WS_ENGSYS_WellDataV5" function. This can be changed in the "ip21-adaptor-cred" credentials file.
PHD Connector
PHD Connectors support the following Query Types:
- Raw Data
- Interpolated