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:
Field | Description |
Step 1 : Add Data Rule Designer | |
DRD Name | Enter the Data Rule Design name. |
Choose the fields | Click ![]() |
Sequence | Enter the sequence number of the Data Rule in this field. |
Category | Enter the category. |
Description | Enter a description for the Data Rule. |
Record Limit | Enter the allowed number of records. |
Type of Action | Select the radio button adjacent to the action type. Available options are the following:
· List · Add · Modify · Delete |
Union | Select the check box adjacent to this field if the Data Rule is a union.
Note: Enabled only for DRD Query Object. Click |
Step 2 : Add Associations | |
Source Object | Click the drop down list and select the source object. |
Source Object Alias Name | Enter an alias name for the source object. |
Join | Click the drop down list and select the join. Available options are the following:
· Inner Join · Left Outer Join · Right Outer Join |
Association Object | Click ![]() |
Association Object Alias Name | Enter an alias name for the association object. |
Source Object Fields | Click ![]() |
Association Object Fields | Click ![]() Click Click |
Step 3 : Add Rules | |
Object Name | Click the drop down list and select the object name. |
Field Name | Click button adjacent to the Field Name field and select a field name from the Lookup window. |
Condition | Click the drop down list and select the condition. |
Value | Enter the value for the expression and click ![]() |
Operator | Click the drop down list and select the operator.
Click |
Grouping | Enter the grouping.
Click |
Step 4 : Choose Fields | |
Available Fields | Select the required fields in the left pane. Use Control/Shift keys to select multiple fields. Click ![]() ![]() ![]() ![]() Use Click |
Chosen Fields | |
Properties | 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.