The Add New Data Rule option enables you to create new Data Rule records in the database. Perform the following procedure to create a new Data Rule record:
- Click button.
The Data Rule Designer – Add page is displayed.
- Populate the form as tabulated:
|Step 1 : Add Data Rule Designer
|Enter the Data Rule Design name.
|Choose the fields
|Click button adjacent to the Select Object field and select an object from the Lookup window.
|Enter the sequence number of the Data Rule in this field.
|Enter the category.
|Enter a description for the Data Rule.
|Enter the allowed number of records.
|Type of Action
|Select the radio button adjacent to the action type. Available options are the following:
|Select the check box adjacent to this field if the Data Rule is a union.
Note: Enabled only for DRD Query Object.
|Step 2 : Add Associations
|Click the drop down list and select the source object.
|Source Object Alias Name
|Enter an alias name for the source object.
|Click the drop down list and select the join. Available options are the following:
· Inner Join
· Left Outer Join
· Right Outer Join
|Click button adjacent to the Association Object field and select an object from the Lookup window.
|Association Object Alias Name
|Enter an alias name for the association object.
|Source Object Fields
|Click button and select the required Source Object Fields from the Lookup window.
|Association Object Fields
|Click button and select the required Association Object Fields from the Lookup window.
Click button to create the association. The association is displayed with Source Object, Source Object Alias, Join, Association Object, Association Object Alias, and Associations Criteria details.
|Step 3 : Add Rules
|Click the drop down list and select the object name.
|Click button adjacent to the Field Name field and select a field name from the Lookup window.
|Click the drop down list and select the condition.
|Enter the value for the expression and click button to create the expression through Build Expression window.
|Click the drop down list and select the operator.
Click button to create the rule. The rule is displayed with Sequence, Object Name, Field Name, Condition, Value, and Operator details.
|Enter the grouping.
|Step 4 : Choose Fields
|Select the required fields in the left pane. Use Control/Shift keys to select multiple fields. Click , , , and buttons to select/deselect fields. The selected fields are displayed in the right pane.
Use and buttons to sort the selected fields in the right pane.
|Select the fields in Chosen Fields pane and update the property details such as Field Name, Field Alias, Group By, and Sorting.
- Click button to complete the definition process.
You can also click button to navigate to the previous screens and edit the report details.
You can also click the button to view the details and button to view the SQL.