<< Click to Display Table of Contents >>
EpmBrowseTypeInstancesFunction |
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.
SELECT * FROM EpmBrowseTypeInstancesFunction(<[string]@typeName>)
•<[string]@typeName>: A String representing the type or class to retrieve. This value must be informed between single quotes
The resulting table contains only the InstancePath field, which is the full path of the items found
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