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 > Database Administration > Entity relationship management > Relationship Manager

Relationship Manager

Relationship Manager is a tool that can automatically discover entity relationships between tables and fields in your HPE Service Manager system by querying the erddef, link, and relatedObjectMap tables, and then save the results in the relation table. It also enables you to manually create relationships and manage them.

Also, Relationship Manager provides output that is consumed by the Missing Reference Report utility and Entity Relationship Diagram utility.

Note To use Relationship Manager, you must have the SysAdmin capability word.

Using Relationship Manager, you can perform the following tasks:

Automatically trigger a reload of all relationships in your system. See Build relationships .
Find entity relationships for tables and fields with other tables. See Search for relationships between specific tables and fields.
Manually add relationships. See Add a relationship record.
Update invalid or fixed relationships. See Update an invalid or fixed relationship.
Update the relationship definition of a relationship record. See Access the relationship definition of a relationship record.

Send Help Center feedback