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

Administer > Database Administration > Data persistence > Database dictionary > Methods for adding database dictionary records > Add an alias field

Add an alias field

Applies to User Roles:

System Administrator

You can add an alias field by using System Definition or by using the Database Dictionary utility. Choose one of the following methods to add an alias field.

Note: You must use the Windows client whenever you need to add or edit a field/key in a database dictionary table.

Add an alias field by using System Definition

In the System Navigator, click System Definition > Tables.

Note: To expand any table in the record list, type the first letter of a table name to jump to that alphabetic section. For example, type o to jump to the oncall table.
Expand Fields, and then select a field.

The Fields and keys definitions for the activity table opens.
In the Aliases section, click New.
In the Alias name field, type an alias name.
Click OK.
Click Save to save your changes.

Add an alias field by using the Database Dictionary utility

To add an alias field by using the Database Dictionary utility:

Click Tailoring > Database Dictionary.
In the File Name field type a file name, and then click Search.

The record opens.
On the Fields tab, scroll through the fields and select one.
Click Edit Field/Key.

The field window opens.
Click Create Alias.
In the Name field, type the name of the alias.
Click OK.
After the record has been updated, click OK again.

Send Help Center feedback