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

Develop > Tailoring > Links > Link maintenance > Virtual joining functionality

Virtual joining functionality

The Virtual Join function allows a single form to display information from many files. You cannot modify virtually joined information but it can link with other files using Find and Fill.

There are special requirements for virtual joins when specifying link information:

The TARGET Format/File Name value in the link record must contain a file name not a form name.
The target field must be a non-concatenated key in the target file.
The target field must be the first instance of the key in the database dictionary’s key array.
The target field must be a scalar field (non-array).
Virtual Join only executes simple links.

While the appearance of virtually joined information is the same as if it exists in the open record, the information is stored in one place and displayed on demand to another.

Note: Use virtual join in any form except record list forms. Use virtual join information as a source field to other information using Find or Fill. Nested virtual joins are not supported.

Send Help Center feedback