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

Syntax

SELECT Name, <type_function>(Value) FROM EpmReadPropertyFunction(<[string]@node>, <[string]@properties>)

Parameters

•<type_function>: Conversion function to define a data type for the resulting values on the Value column. Possible values are intval (integer), doubleval (floating point), charval (String), to_date (date and time), and opc_str (OPC UA quality String)

•<[string]@node>: Object or objects to search for. Users must inform a full address or addresses, starting with 'ElipseDataModel' or 'EPMModel', between single quotes and separated by commas

•<[string]@properties>: Property or properties to search for. Name or names must be informed between single quotes and separated by commas

Result Fields

•Name: Full path of a property retrieved

•Value: Value of a property

Example

To return a table with information about the 'Power' property in floating point format for the AirConditioner1 object on Elipse Data Model, use the next statement.

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

EpmReadPropertyFunction function