Retrieve element extended properties
- Last UpdatedSep 29, 2022
- 1 minute read
- PI System
- PI OLEDB Enterprise 2019
- Developer
SELECT eh.Path + eh.Name + ep.Name Path, ep.*
FROM NuGreen.Asset.vElementHierarchy eh
INNER JOIN NuGreen.Asset.vElementVersion ev ON ev.ID = eh.ElementVersionID
INNER JOIN NuGreen.Asset.vElementExtendedProperty ep ON ep.ElementVersionID = ev.ID
WHERE eh.Path LIKE N'\NuGreen\Little Rock\Extruding Process\%'
AND eh.Effective <= N'01-Aug-2011' /*query date*/
AND eh.Ineffective > N'01-Aug-2011' /*query date*/
OPTION (FORCE ORDER)