Show TOC

Background documentationDynamic Expression Editor Dialog Box Locate this document in the navigation structure

 

You use the Dynamic Expression Editor dialog box to define dynamic field values used to define specific behavior in a property of a model element. More information: Defining Dynamic Expressions

You access the Dynamic Expression Editor dialog box by clicking the function (fx) icon displayed to the right of an attribute or property field that supports dynamic expressions, or choosing the Define expression option from a dropdown list (where available).

The Dynamic Expression Editor dialog box contains the following items:

Item

Description

Expression pane

The area on the top left of the dialog box that enables you to construct dynamic expressions. You can write an expression as free text, or you can create it by dragging functions from the Function pane to the Expression pane. When you define a dynamic expression, prefix it with an equal (=) symbol. In certain cases, the equal (=) symbol is added automatically when you drag an item to the Expression pane.

Function pane

The area on the right of the dialog box that displays a list of functions you can use when writing a dynamic expression. A descriptive tooltip is provided for each function. In addition, the icon to the left of each function represents the data type returned when the function is evaluated.

Functions are grouped into the following categories:

  • Data Fields, which contains all of the fields available from the data services in your model. This can be useful if, for example, you want a particular action type, such as a hyperlink, to represent a specific output in a query.

  • Recently Used, which provides easy access to the functions you use often, up to a maximum of eight functions.

  • All available functions, divided into the following categories: Text Functions, Numeric Functions, Date Functions, Time Functions, Conditional Functions, and Scientific Functions.

  • Operators, which lists all the mathematical, logical, and comparison operators available for use in the expression.

More information: Tables of Functions

Description field

The area below the Expression pane that enables you to add any text related to the current expression, such as a reminder or a note to other users. Click anywhere in the field to open a Description dialog box in which you can enter, view, or modify descriptive text.

Message pane

The area below the Description field that displays the validation results returned for the expression when you click the Check button. More information: Messages in the Dynamic Expression Editor Dialog Box

Help pane

The area below the Function pane displays a short description of the function currently selected in the Function pane. You can click the Help on this function link below the function description to display an online help topic about the function, including syntax and examples.