Instead of typing Structured Query Language (SQL) statements into the Expressions field, you can use the Expression Builder dialog box in the Conditional Expression Manager application to build a condition. To access this dialog box, in the Expression field, click Condition Expression Builder .
Every expression begins with an object. There are two ways to choose an object: you can choose one in another application (such as Escalations or Work Flow) or you can choose one in the Conditional Expression Manager application. Once you choose an object, the system filters the list of attributes to show only those that apply to that object. The Conditions and Operators table windows display common SQL syntax. If a function requires arguments, the system inserts empty brackets in the position where you insert the arguments.
Click Expression Builder in the Expression field. The Expression Builder dialog box opens.
Click Select Value to enter a value in the Object Name field.
Note: If you selected an object in another application (such as Escalations or Work Flow), this field will already be populated.
In the Expression field, place your cursor where you want to enter the attribute, condition, operand, etc. before adding it.
Note: You can also manually type elements of the condition in the field.
In the list box, click the plus sign to expand the tree view. The system displays the list of attributes associated with the object.
Click the icon next to an attribute to add it to the Expression field.
Select a condition, operator, math function, or keyword, or expand the Miscellaneous table window to select a date or classification path.
If appropriate, select attributes and SQL syntax to continue to build your expression.
To test the expression, expand the Miscellaneous table window and click Test Expression. Correct any syntax errors as needed.
When you are finished, click OK.