<< Click to Display Table of Contents >>   EpmBasicVariablesView

Returns a table with a list of all existing variables of type BasicVariables on an EPM Server.

 

Syntax

SELECT * FROM EpmBasicVariablesView()

 

Result Fields

•Name: Name of a variable

•Description: Description of a variable

•EU: Engineering unit configured in a variable

 

Example

To return data from variables with a BasicVariables type containing the expression "Elipse" in the Name field, use the next statement.

SELECT * FROM EpmBasicVariablesView() WHERE Name LIKE '%Elipse%'