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 |
|
- Methods for adding database dictionary records
- Field name requirements
- Create an inactive database dictionary record
- Create an active database dictionary record
- Add a structure to the database dictionary
- Add an alias field
- Add an array
- Add fields to a structure
- Create a database dictionary record by importing RDBMS columns
- Designate unique fields in the array of structures
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.
Related topics
Alias fields
Arrays
Structures
Arrayed structures
Adding a key
Methods for updating database dictionary records
Modifying a key
Methods for deleting database dictionary records
Deleting a key
Add a field to an existing database dictionary record
Open a database dictionary
Access the Database Dictionary utility
Regen a database dictionary