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.51

Develop > Tailoring > Data management > Data validation > Validity validation rules

Validity validation rules

Each entry must have at least one entry in the Files/Formats field.
Each entry in the Files/Formats field must be a valid database dictionary name or form name.
The Field Name must be defined in each database dictionary listed in the Files/Formats array or to the database dictionary associated with the form.
The data type of the Field Name must be the same for each file listed in the Files/Formats array or for the file associated with the form.
The Unique ID is a user-provided value that uniquely identifies the record.
The unique key of the validity table contains the following fields: field.name, sequence, and filename. Each combination of the Field Name, Sequence, and each element of the Files/Formats array in the validity record must also be unique within the validity table. This check is performed before the record is added or updated. If duplicates are found, the add/update action is not performed, and the following message is displayed: This record contains an invalid duplicate key.
The value in the Alt Application field must be a valid RAD application.
The Secondary File Query Filename value must be a valid database dictionary name.
The Lookup Fields must be defined to the Secondary Query Filename and their data types must be the same as the Field Name.
The Val Fields must be defined to the Files/Format file and their data types must be the same as the Field Name.
The Record list format must be a valid form name.
The value in the No Recs Option field must be the word Proceed, or Return. If neither is selected the system defaults to Proceed when the record is validated.

Send Help Center feedback