A rule is a SQL expression defined using the attributes of an event structure. Rules that share a common event structure belong to the same rule class. A rule has a description, action preferences, and a condition. Action preferences describe the event values associated with each rule for action execution. A rule condition is a SQL expression of the rule using the attributes defined in the event structure.

This is the database schema in which the rule will be created. This information is derived from the connection specified in the previous step, and is not editable.

Choose the Rule Class from the drop-down list that this rule will be stored in. The list includes all rule classes defined in the database schema.

Enter an identifier (name) for this rule. The name must be unique.

Enter a description for this rule. This description will be stored in the database schema along with the rule.

You can choose to build the rule condition in an XML tree structure editor by pressing the Build button, or directly enter a textual SQL expression of the rule in the text area.

Press the Rule Action Preferences button to open a dialog box to edit the Action Preferences for this rule. To enter action preferences (event values) associated with this rule, look for the appropriate event attribute from the Action Categories column whose event value you want to enter, then place the cursor in its respective User Input column field and enter an event value. Event values can be scalar values or raw text.

Note: Note: Your SQL expression syntax within the XML tree structure is not checked in edit mode. Any mispellings, typos, and SQL expression syntax errors will go undetected until either you notice and correct them in the current session, or when you click Finish to save your changes and end the create rule session. When you click Finish, the SQL expression undergoes a Rules Manager validation check and only then will mispelling of attribute names and SQL expression syntax errors be discovered. If there is a problem, an error message will display upon a page refresh, letting you check and edit your attribute names and SQL expression syntax. You cannot save your new rule condition until the SQL expression validates successfully.

Related Topics

Rule Creation Wizard

Primitive Rule Condition Editor

Composite Rule Condition Editor

Event Structure Wizard

Rule Class Wizard