Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI SQL Data Access Server (RTQP Engine)

RTQP Engine catalogs

  • Last UpdatedDec 19, 2022
  • 1 minute read

For information about how to create other catalogs besides the fixed Master catalog, use the CREATE functions described in SQL statements or see the PI SQL Commander Lite 2018 User Guide available at the AVEVA Customer Portal Products page.

Catalog: Master: Category

Data model object

Type

Category

Table

Catalog: Master: Element

Database object

Type

Archive

Table

Attribute

AttributeCategory

AttributeTemplate

AttributeTemplateCategory

Element

ElementCategory

ElementHierarchy

ElementTemplate

ElementTemplateCategory

FindElements

Table-valued function

GetPlotValues

GetSampledValue

GetSampledValues

GetSummaries

GetSummary

Value

Table template

GetSampledValue

Table-valued function template

GetSampledValues

GetSummaries

GetSummary

Catalog: Master: EventFrame

Database object

Type

Attribute

Table

AttributeCategory

AttributeTemplate

AttributeTemplateCategory

EventFrame

EventFrameCategory

EventFrameTemplate

EventFrameTemplateCategory

FindEventFrames

Table-valued function

GetPlotValues

GetSampledValue

GetSampledValues

GetSummaries

GetSummary

GetSummary (based on event frame start and end times)

Value

Table template

GetSampledValue

Table-valued function template

GetSampledValues

GetSummaries

GetSummary

GetSummary (based on event frame start and end times)

Catalog: Master: UnitOfMeasure

Database object

Type

Class

Table

UnitOfMeasure

In This Topic
TitleResults for “How to create a CRG?”Also Available in