Default language.

Expression editor


The expression editor is a dialog box that appears in BMC Remedy Developer Studio whenever you click the ellipsis button in a field that requires an expression. It presents the data types allowed for the expression in the current context, such as the field names from the primary form, BMC Remedy AR System server keywords, the results of a function, or static values. Additional data types depend on the workflow action type. The expression editor also includes buttons for the most commonly used operators.

To build an expression, you select from the options in the expression editor. For example, the following figure shows a Run If qualification in progress in the expression editor. In this case the developer has added the fields Status and Short Description, along with the operators AND and !=, and is about to add the keyword $NULL$ to the end of the expression.

When you highlight an entry in the lists of fields, keywords, and other data types, BMC Remedy Developer Studio provides information about the selection in the information area of the expression editor.

For an example procedure that describes building a Run If qualification in a filter, see Filter qualification examples. For an example of using an expression to map fields in a workflow action, see Mapping-fields-to-values.

The Expression Editor dialog box
 (Click the image to expand it.)

DSExpressionEditor.gif

Run If qualifications and other expressions can contain any valid sequence of operators, wildcards, and keywords, as shown in the following examples:


'Submitter' LIKE "Jackson%"
'Create Date' < $TIMETSTAMP$ - (60*60*24)

Operators-wildcards-keywords-and-NULL-values describes how each of these expression components is used and evaluated in BMC Remedy AR System.

When entering an expression, make sure that it is acceptable to the database on which BMC Remedy AR System is running. Avoid creating comparisons with fields of unlimited length, because the database might not support that capability. For more information about fields of unlimited length, see Field-Properties.

Warning

Note

Microsoft SQL Server and Sybase RDBMSs remove hard returns at the end of character strings. This can result in incorrect qualification syntax. To resolve this problem, BMC Remedy AR System adds a space before any hard return at the end of a string.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Remedy Action Request System 20.02