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.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.41

Administer > Application Setup > Process Designer > Adding a rule > Add a Validate against Table rule

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 If the field value does not match a value in the specified table, the system displays a pop-up message and sets the cursor to that field when the rule is not followed.

To add a Validate against Table rule:

Click Tailoring > Process Designer.
Click Rule Sets > Search.
Select the Rule Set to which you want to add the rule.
Click Add Rule to open the Select Rule Type page.
Click Validate against Table.
Type the Rule Description.
Click Edit to add a condition.

Note If you do not specify a condition, it will default to Always.
Select the error message type: Pop-up or Screen to display 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 you are validating against 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 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 rule.

Send Help Center feedback