Configuring action SQL

When a modification is made to a Siebel case, the changes are reflected in the ObjectServer. To determine what actions take place in the ObjectServer, you need to edit the action SQL files. These files are ObjectServer SQL-based, therefore you have all of the language facilities available to you. You must create an action SQL file for each of the event types.

The following SQL statement updates the Severity field:

update alerts.status set Severity = $(siebelfield:Severity);

In this example, the $ represents an expansion statement and information enclosed within the parentheses must be resolved. The siebelfield statement specifies the Siebel field. The Severity statement specifies that severity conversions must be used and applied. The colon (:) is a statement separator.