PI point selection using queries

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 PI Point Query Syntax Overview.

The following lists the common PI point attributes and operator types used by PSC3.

Note: Actual PI point attribute type may differ from how the connector interprets the operator types associated with the attribute. All attributes are case-insensitive.

Integer PI Point attributes

• Archiving

• Compressing

• Compmax

• Compmin

• DisplayDigits

• ExcMax

• ExcMin

• EventNumb

• Filtercode

• Future

• Location1

• Location2

• Location3

• Location4

• Location5

• Node Numb

• Offset

• PointId

• RecNo

• Scan

• Shutdown

• SrcPtId

• Step

• TotalCode

• UserInt1

• UserInt2

Float PI Point attributes

• Clamp

• CompDev

• CompDevPercent

• Convers

• ExcDev

• ExcDevPercent

• FilterNumb

• Period

• Span

• TypicalValue

• UserReal1

• UserReal2

• Zero

String PI Point attributes

All remaining PI point attributes.

Attribute Type Supported Operators

The following table lists the supported query operations on a given attribute type.