Working with the EDE Expression Builder - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1

The EDE Expression Builder EDE Expression Builder is designed to create expressions based on data from an EDE View. The Expression string is based on EDE Attributes, functions, operators, and constants. Results are displayed in a new Expression column, which is initially created after the last column of the current EDE View. The Expression column behaves like any other EDE column and can be sorted, filtered, and moved in the grid. The name of the Expression's column header is based on the name you entered in the Expression Name field. You can create multiple expressions for one EDE View. Each expression is displayed in its own column. The columns of the EDE Expression Builder are saved together with the current EDE View.

To open the EDE Expression Builder, select EDE Expression Builder from the Actions toolbar. A dialog opens in the EDE View's main window.

The Expression Builder contains the following sections:

Expression Name

Displays the name you enter for the expression. The expression name should be unique.

Expression Panel

Displays your function based on the expressions you select. The expressions are color coded, based on the following:

Result Preview

Displays the returned result it finds. Lists the first result from the EDE View's first row, as an indication that it meets the condition you specified.

Function Information

Displays the function's syntax and help information.

Attributes

An alphabetical list of all the EDE attributes in the current EDE View. Any already created EDE Expressions are also listed in the Attributes section.

Search Attributes

Allows for searching from the Attributes list.

Functions

A list of pre-set formulas to perform calculations. For details see, Operators, Functions and Constants Panels

Operators

Math symbols, for example: -, +, /, *, %, <, =.

Constants

Boolean options for the expression when using a logical function. Choose from False, True, Null.

EDE Expression Results

EDE Expression Builder can be edited from the Expression's column header, in the EDE View. Select the EDE Edit Expression, next to the Expression's column name. To save your changes, select the OK button. The EDE View re-generated to reflect the changes.

  • EDE Expressions are based on the attributes of an EDE View. In some cases these attributes are not known when generating an EDE View from the Query Builder. In these cases you use conditional expressions.

  • When editing in Query Builder, an EDE View that includes an EDE Expression, it becomes invalid when parts of the data gets modified in Query Builder. The results in the Expression column displays a syntax: #ERROR. You need to review and modify your Expression in order to make the string and the arguments valid again.

  • When a non-unique name (for example, an existing Attribute), or no name is entered in the Expression Name field, the software generates a name using the following naming convention: Expression 1, Expression 2, etc.

  • To remove an Expression, select the Remove Item button, in the Expression Builder.

  • EDE Expression columns, saved as part of an EDE View will be included when generating an EDE report.

  • EDE Expression column names, and Expression data are included in searches made using the complex filter of an EDE View.