Administer > Application Setup > Process Designer > Adding a rule > Add a Field Validation Against a Table rule

Add a Field Validation against a Table rule

Applies to User Roles:

System Administrator

Implementer

This rule enables you to validate a field against a field in another table and fill data into other fields. You can also filter the data you are validating against, and fill data into other fields.

Note If the field value does not match a value in the specified table, the system displays a message and sets the cursor to that field when the rule is not followed.

To add a Field Validation against a Table rule, follow these steps:

  1. In the System Navigator, click Tailoring > Process Designer > Rule Sets.
  2. Click Search to open the Rule Set form, and then select the rule set to which you want to add the rule.

    Note You can edit user-defined rule sets only. Out-of-box rule sets are labeled as HPE Proprietary and cannot be modified.

  3. Click Add Rule to open the Select Rule Type page, and then click Validate Against Table.
  4. In the Rule Description field, type a description of your new rule.
  5. Click Edit to add conditions to the rule.

    Note If you do not specify a condition, the value defaults to Always.

  6. Select the field to validate from the drop-down list.
  7. Select the name of the table you want to validate against.
  8. Select the name of the field you want to validate against.
  9. You can filter the data that you are validating against by using a standard RAD query.

    For example, the following field entries will validate only for cm3r with the current field name ("Demo String2," in this example) of the workflow:

    Current Field Name field: Demo String2

    Validate Against Table field: ModuleStatus

    Validate Against Field field: Status

    Filter field: module="cm3r"

  10. Click Click Here to Add Fill Information to enter Fill From and Fill To fields.

    Note The Fill From field represents the fields of the validation table against which it validates. The Fill To field represents the fields in the current table being validated.

  11. Click OK to add the new rule to the rule set.