Expression Builder

Expression Builder is used at various places in the Aras ProAppDesigner like in creating Display Condition, Default Value, Conditional Formatting, Validation Rules, Property Filter. Using Expression Builder, you can create complex boolean and scalar expressions. Expressions can contain Item properties, operators, values, grouping operator (‘( )’), logical operators (‘AND’, ‘OR’). Various editors are used for showing values based on the selected property type. Existing expression can be updated by selecting individual sub-expression or elements with mouse. You can also navigate expression elements using navigation keys. Selected keyword can be deleted by clicking on the delete icon. If no element is selected, by clicking on delete icon will remove the whole expression.

If no element is selected in the expression, by inserting new property expression or other operators will insert at the beginning of the expression. If any element is selected in the expression, insert operation will insert the new element right after the selected element.

For the date property, Value field can take a specific date or a keyword. In order to build a boolean expression based on current date, value can contain keywords CURRENT_DATE and CURRENT_DATETIME. These keywords will be replaced at runtime before evaluating the expression with actual current date or datetime.

Ex1: Created On LessThanEqualTo CURRENT_DATE
Ex2: Effective Date LessThanEqualTo CURRENT_DATE + 2
Ex2: Modified On LessThanEqualTo CURRENT_DATE – 7

For the user property, Value field can take any text or keyword. In order to build a boolean expression based on current user, value can contain keyword CURRENT_USER. This keyword will be replaced at runtime before evaluating the expression with the logged-in user.

Ex1: Created By EqualTo CURRENT_USER
Ex2: Owned By NoteEqualTo CURRENT_USER