Current hierarchy
- Last UpdatedFeb 07, 2023
- 1 minute read
- PI System
- PI OLEDB Enterprise 2019
- Developer
Alternatively, queries that refer to the current element hierarchy can also be formulated with simplified element tables. As there is just one version valid at the current time, the simplified E-R model does not reference a table of element versions. Typical queries are as follows:
-
Element attribute query = inner join of Asset.ElementHierarchy and Asset.ElementAttribute.
-
Element extended property query = inner join of Asset.ElementHierarchy and Asset.ElementExtendedProperty.
-
Time-series data query = inner join Asset.ElementHierarchy, Asset.ElementAttribute, and any one table or TVF dedicated to element attributes from the Data schema.