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

Syntax

SELECT * FROM EpmBrowseTypeInstancesFunction(<[string]@typeName>)

Parameters

•<[string]@typeName>: A String representing the type or class to retrieve. This value must be informed between single quotes

Result Fields

The resulting table contains only the InstancePath field, which is the full path of the items found

Example

To return all items whose type is equal to 'Room' in paths containing the expression '[Elipse-RS]', use the next statement.

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

EpmBrowseTypesInstancesFunction function