Returns a table containing a list of items found on the address indicated in the @path parameter.

Syntax

SELECT * FROM EpmBrowseModel(@path)

Parameter

•@path: A String representing the full path of the node to query. This node can be from the Contextual Model, from Elipse Data Model, or from EPM Model tree, and it must be informed between single quotes

Resulting Fields

•Child: Name of the items belonging to the node informed in the @path parameter

•Type: Type or class of the items found

Usage Example

To return information about the name and type of the items contained on a certain address in Elipse Data Model, use the next declaration.

SELECT * FROM EpmBrowseModel('ElipseDataModel/DataModel/Elipse/[Elipse-RS]/Floor10/Room1')