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 Manager

Develop > Tailoring > Data management > Data validation > Look-up processing > Add range definitions

Add range definitions

Click Tailoring > Database Manager.
Type validity in the Form field, and then click Search.

A list of the validity form records in your database opens.
Double-click validity.summary, and then click Search.

The Validity Table Specifications summary form opens.
Put the cursor in the first line of the Range Summary array.
Click More or the More Actions icon, and then choose Edit Line.

The Validity Range Detail Specification form opens.
Complete the record as necessary, and then click Add.

For additional information on writing conditions and expressions, see information on system language in the related topics.

Note: It is possible that the same range could be allowed under multiple conditions within the same validity record; therefore, the system does not check for duplicate field values.

Important: If the character field starts with a < or > symbol, you must insert a blank space before it. These symbols are dropped by the Service Manager parser, unless preceded by a blank space.

The record is added and the buttons in the tool tray change.
Click Back to return to the validity record.

The system combines the values you entered in the Min Desc and Max Desc fields with the relational operator you specified to produce the string that appears in the Range Summary array.
Put the cursor in the next blank line of the Range Summary array and repeat the above steps until you have established all the ranges for your field.
Click Save to add the record to the validity file.