<< Click to Display Table of Contents >>
EpmBrowseModel Function |
Returns names and types of items belonging to the informed Contextual Model node.
EpmBrowseModel(
@path nvarchar(max))
Where:
•path: Full path of the Contextual Model node to search for items
This query returns a table with two columns, the first one (Child) with the name of the items belonging to the requested node and the second one (Type) the respective types, which can be Folder, BasicVariable, or ExpressionVariable. Usage example:
SELECT Child AS childName, Type AS type
FROM dbo.EpmBrowseModel('ContextualModel/Folder01')
In this case, the query returns a table with all names and their respective types of items belonging to Folder01 folder of ContextualModel node.