Instead of typing SQL statements into a condition field, you can use the SQL Expression Builder dialog box to build a condition. You can gain access to this dialog box from more than one application.
The system passes the object from the escalation, service level agreement, or conditional expression manager into the SQL Expression Builder dialog box. It then filters the list of attributes to show only those that apply to that object. The Condition 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.
Perform one of the following actions:
Open or create an escalation in the Escalations application or on the Escalation tab in the Service Level Agreements application.
Create a condition in the Conditional Expression Manager application.
In the Condition, Escalation Point Condition, Additional SLA Criteria, or Expression field, click SQL Expression Builder . The SQL Expression Builder dialog box opens.
In the Expression field, place your cursor where you want to enter the elements of the condition.
Note: You also can 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 escalation's object.
Click the icon next to an attribute to return it to the Expression field.
Select a condition or operator, or expand the Miscellaneous table window to select a date or a classification path.
If appropriate, select attributes and SQL syntax to continue to build your SQL expression.
To test the expression, expand the Miscellaneous table window and click Test Expression. Correct any syntax errors as needed.
After you create the SQL expression, click OK to return to one of the following with the expression in the appropriate field:
the Conditional Expression Manager application
the Escalation or Service Level Agreement tab