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

Administer > Database administration > Entity relationship management > Entity Relationship Diagram utility > Identify misconfigured reference fields

Identify misconfigured reference fields

Applies to User Roles:

System Administrator

A reference field retrieves data from another table instead of the table to which it belongs. An example reference field is the affected.item field in the probsummary table, which retrieves data from the device table. A reference field must have the correct referenced table configured in the datadict record. The Entity Relationship Diagram utility can help you identify reference fields whose referenced table is not configured correctly.

To identify misconfigured reference fields, follow these steps:

Navigate to Tailoring > SQL Utities > Entity Relationship Diagram.
In the Table Name box, enter the name of a referenced table. For example, enter device.
Click Search.

Service Manager generates an ERD for the specified table.
Select the Logical view.
Select Link and then As Target as the filter.
Select the key of the referenced table. For example, select the logical.name field of the device table.
Check for red connector lines between the referenced table and other tables. If a red line connects the referenced table and another one, check that table for fields that are enclosed in a red box. Such fields are misconfigured reference fields.

The following figure shows an example, which indicates the affected.item field in the probsummary table does not have a referenced table configured.
Click here to show or hide links to related topics.

Related concepts

Entity Relationship Diagram utility
Specify a referenced table for a field

Related tasks

Interact with an entity relationship diagram

Send Help Center feedback