Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
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 |
|
|
Either word in a topic |
|
|
Topics that do not contain a specific word or phrase |
|
|
Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
A combination of search types | ( ) parentheses |
|
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.
-
Related concepts
Entity Relationship Diagram utility
Specify a referenced table for a field
Related tasks