Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Words and Phrases
| Search for | Example | Results |
|---|---|---|
| A single word | cat
|
Topics that contain the word "cat". You will also find its grammatical variations, such as "cats". |
|
A phrase. You can specify that the search results contain a specific phrase. |
"cat food" (quotation marks) |
Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase. |
Using Boolean Operators
| Search for | Operator | Example |
|---|---|---|
|
Two or more words in the same topic |
|
|
| Either word in a topic |
|
|
| Topics that do not contain a specific word or phrase |
|
|
| Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
| A combination of search types | ( ) parentheses |
|
- Adding a rule
- Add a Launch a URL rule
- Add a Run a Macro rule
- Add a Call a Process rule
- Add a Case Exchange rule
- Add a Run a Wizard rule
- Add a Clear Fields rule
- Add a JavaScript Validation rule
- Add a Run JavaScript rule
- Add a Set Mandatory Fields rule
- Add a Set Mandatory Variables rule
- Add a Send Notifications rule
- Add a Launch a Script rule
- Add a Send HTML Email rule
- Add a Start or Stop Clock rule
- Add a Set Field rule
- Add a Set Field from Number rule
- Add a Validate Date rule
- Add a Validate against List rule
- Add a Validate against Table rule
- Add a Validate Text/Number rule
- Add a Popup Message Box rule
- Add an Assignment rule
- Add a Run Action rule
- Add a Run Scheduled Action rule
- Group rules
Add a Validate against 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 The Validate against Table rule does not include the Set Mandatory Fields rule, so that you cannot use the Validate against Table rule to verify whether a field is empty or not. Before you create a Validate against Table rule, it is recommended that you first add a Set Mandatory Fields rule to verify whether the field is empty or not.
To add a Validate against Table rule, follow these steps:
- In the System Navigator, click Tailoring > Process Designer > Rule Sets.
-
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 Micro Focus Proprietary and cannot be modified.
- Click Add Rule to open the Select Rule Type page, and then click Validate against Table.
- In the Rule Description field, type a description of your new rule.
-
Click Edit to add a condition.
Note If you do not specify a condition, it will default to Always.
- Select Pop-up or Screen to set the type of error message that is displayed during validation.
- Select the field to validate from the drop-down list.
- Select the name of the table you want to validate against.
- Select the name of the field you want to validate against.
-
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"
-
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.
-
(Optional) If you want the field to be validated whether its value changes or not, select the Always Check Validity check box.
If this option is not selected, the system validates the field only when its value changes.
- Click OK to add the new rule to the rule set.
Related topics
