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

Administer > Database Administration > Entity relationship management > Relationship Manager > Search for relationships between specific tables and fields

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.

Send Help Center feedback