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.
Words and Phrases
| 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. |
Using Boolean Operators
| 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 |
|
Search for relationships between specific tables and fields
Applies to User Roles:
System Administrator
In Relationship Manager, you can search for relationships by one or more of the following fields: Table Name, Field Name, Definition Type, and Status.
To search for relationships between specific tables and fields, follow these steps:
-
Navigate to Tailoring > Tailoring Tools > Relationship Manager to open Relationship Manager.
-
In the Table Name field, type the name of either the source or the target table. For example, operator.
-
In the Field Name field, type the name of a field in the table you specified. For example, name.
-
In the Definition Type field, select a definition type: link, erddef, relatedObjectMap, or manual.
-
In the Status field, select a status: new, invalid, or fixed.
-
Click Search.
A list of records is displayed, showing the relationships between the specified field and fields in other tables.
Note You can also perform a search by leaving some or all of the search fields empty. We strongly recommend that you review all relationships to ensure they are correct, because some other features (such as the Entity Relationship Diagram utility and the Missing Reference Report utility) heavily rely on the correctness of your relationship records.
-
Double-click a record from the list to open the details page and view the details.
A relationship record may contain the following fields.
Field Description Notes Source Table One of the following fields depending on the definition type of the relationship record (see Definition Type in this table):
- First Filename in the erddef definition
- Name in the link definition
- Source Table in the relatedObjectMap definition
Source Field One of the following fields depending on the definition type of the relationship record:
- Field Names from First Filename in the erddef definition
- Source Field Name in the link definition
- Source Field in the relatedObjectMap definition
Relationship Type The type of the relationship. It can have one of the following values:
- One to Many
- Many to One
- One to One
- Many to Many
System-generated Target Table One of the following fields depending on the definition type of the relationship record:
- Second Filename in the erddef definition
- Target File Name in the link definition
- To Table in the relatedObjectMap definition
Target Field One of the following fields depending on the definition type of the relationship record:
- Field Names from Second Filename in the erddef definition
- Target Field Name in the link definition
- To Field in the relatedObjectMap definition
Definition Type The type of the relationship definition, which indicates how the relationship is defined:
- link: the relationship is defined in a link record.
- erddef: the relationship is defined in an erddef record.
- relatedObjectMap: the relationship is defined in a relatedObjectMap record.
- manual: the relationship is manually defined.
System-generated Status The status of the relationship:
- new: the relationship was automatically created and contains valid data.
- fixed: the relationship was manually created or updated and contains valid data.
- invalid: the relationship was automatically created and contains invalid data (any of the SQL table names or SQL field names cannot be found).
System-generated Has Post Expression Indicates if the link record of the relationship has a post expression defined. Applicable only for relationships whose definition type is link:
- true
- false
Note A post expression is an expression that is executed after the link function is triggered by clicking Fill.
System-generated Source SQL Table The SQL Table name of the source table System-generated Source SQL Field The SQL Name of the source field System-generated Target SQL Table The SQL Table name of the target table System-generated Target SQL Field The SQL Name of the target field System-generated Definition Query The query of the relationship definition
Note This field is empty if the relationship is manually created.
System-generated Enable Data Reference Check This option indicates if this relationship is skipped when you run a data reference check against its source file or target file:
- If this option is selected: not skipped
- If this option is not selected: skipped
System-generated Note You can use one of the following methods if you have any invalid relationships:
- Update its relationship definition using the Goto Definition button. See Access the relationship definition of a relationship record.
- Add a new relationship for it by using the Copy button. See Add a relationship record.
- Update the relationship if the Definition Type is link. See Update an invalid or fixed relationship.
Related concepts
Related tasks
