PI point selection using queries
- Last UpdatedMay 01, 2026
- 2 minute read
- PI System
- PI System Connector 3 3.0
- Connectors
To assist in selecting PI points for data replication, AVEVA™ PI System Connector 3 (PSC3) supports two options for defining PI point queries:
-
Include PI Points that match this query associated with the Replicate Data Archive only data source replication
-
Send snapshot data for PI Points that match this query option under the Overview tab for all data source configurations.
PI point selection queries can range from simple to complex. It is recommended to use the PI System Explorer > Search > Tag Search tool to help develop the desired query or queries. Tag search syntax can be found using the PI System Explorer > Help > AF SDK Reference and searching for PIPoint Query Syntax Overview.
The following table lists the common PI point attributes and operator type used by PSC3.
Note: Actual PI point attribute type may differ from how the connector interprets the operator type associated with the attribute. All attributes are case-insensitive.
|
PI Point Attribute |
Attribute Type |
PI Point Attribute |
Attribute Type |
|---|---|---|---|
|
Archiving |
Integer |
Shutdown |
Integer |
|
Compressing |
Integer |
SrcPtId |
Integer |
|
Compmax |
Integer |
Step |
Integer |
|
Compmin |
Integer |
TotalCode |
Integer |
|
DisplayDigits |
Integer |
UserInt1 |
Integer |
|
ExcMax |
Integer |
UserInt2 |
Integer |
|
ExcMin |
Integer |
Clamp |
Float |
|
EventNumb |
Integer |
CompDev |
Float |
|
Filtercode |
Integer |
CompDevPercent |
Float |
|
Future |
Integer |
Convers |
Float |
|
Location1 |
Integer |
ExcDev |
Float |
|
Location2 |
Integer |
ExcDevPercent |
Float |
|
Location3 |
Integer |
FilterNumb |
Float |
|
Location4 |
Integer |
Period |
Float |
|
Location5 |
Integer |
Span |
Float |
|
Node Numb |
Integer |
TypicalValue |
Float |
|
Offset |
Integer |
UserReal1 |
Float |
|
PointId |
Integer |
UserReal2 |
Float |
|
RecNo |
Integer |
Zero |
Float |
|
Scan |
Integer |
All other attributes |
String |
The following table lists the supported query operations on a given attribute type.
|
Attribute Type Supported |
||||
|---|---|---|---|---|
|
Operator |
Description |
Attribute Type: Integer |
Attribute Type: Float |
Attribute Type: String |
|
= |
The EQUALS operator |
Yes |
Yes |
Yes |
|
<> |
The NOT EQUALS operator |
Yes |
Yes |
Yes |
|
< |
The LESS THAN operator |
Yes |
Yes |
No |
|
<= |
The LESS THAN OR EQUAL operator |
Yes |
Yes |
No |
|
> |
The GREATER THAN operator |
Yes |
Yes |
No |
|
>= |
The GREATER THAN OR EQUAL operator |
Yes |
Yes |
No |
|
In |
The MULTIPLE OR CONDITIONS operator |
No |
No |
No |