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 Manager

Develop > Tailoring > Links > Entity Relationship Diagram creation utility > Create an ERD record

Create an ERD record

Applies to User Roles:

System Administrator

An Entity Relationship Diagram (ERD) is a graphic description of the logical structure of a database. Database administrators often rely on conceptual and physical data models to understand the relationships among tables, records, and data, and to produce reports.

To create an ERD record:

Click Tailoring > Tailoring Tools > ERD Create Records.
Type the Name (usually the application name) for the ERD Create record.
Click More or the More Actions icon and then select Add Files for Module.

Note: The Add Files process will fail if the name of the ERD record is not associated with one or more Data Policy records.
Click More or the More Actions icon and then select Add Master Links.
Click More or the More Actions icon and then select Add all Related Links.
Click Add.
Click OK.

Note: You can add relationships manually from the Manual Relationships tab. Use this tab to define relationships that do not occur in any of the automatically discovered categories. Each relationship that you create manually also appears in the ERD.

Related concepts

DDL mode
Entity Relationship Diagram creation utility
What are Master link records?
What are related link records?
What is the required input for ERD Create?

Related references

Checklist: Creating an ERD record for an application
Checklist: Generating a DDL file