Returns a table with a list of all items found on the Elipse Data Model or EPM Model tree with the type informed in the @typeName parameter.

Syntax

SELECT * FROM EpmBrowseTypeInstancesFunction(@typeName)

Parameter

•@typeName: A String representing the type or class of the items to query. This value must be informed between single quotes

Resulting Field

•InstancePath: Full path of the items found

Usage Example

To return all items whose type is equal to "Room" on paths containing the expression "[Elipse-RS]", use the next declaration.

SELECT * FROM EpmBrowseTypeInstancesFunction('Room') WHERE InstancePath LIKE '%[Elipse-RS]%'