Returns a list with information about one or more simple properties informed in the @properties parameter from one or more modeled objects informed in the @node parameter. These properties have static data.

Syntax

SELECT Name, Value FROM EpmReadPropertyFunction(@node, @properties)

Parameters

•@node: Object or objects to query. Users must inform the full address or addresses, starting with 'ElipseDataModel' or 'EPMModel', between single quotes and comma-separated

•@properties: Property or properties to query. The name or names must be informed between single quotes and comma-separated

Resulting Fields

•Name: Full path of the property queried

•Value: Value in the property

Usage Example

To return a table with information about the Power property as a floating point for the AirConditioner1 object in Elipse Data Model, use the next declaration.

SELECT Name, Value FROM EpmReadPropertyFunction('ElipseDataModel/DataModel/Elipse/[Elipse-RS]/Floor10/Room1/AirConditioner1', 'Power')