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 |
|
- Database dictionary
- Database dictionary records
- Making database dictionary changes
- Database dictionary data types
- Alias fields
- Access the database dictionary utility
- Enable DDL logging of database dictionary changes
- Open a database dictionary
- Copying a database dictionary
- Methods for adding database dictionary records
- Methods for deleting database dictionary records
- Methods for updating database dictionary records
- Resetting a database table
Alias fields
An alias field is a field that has a different name but the same index, level, and type as an existing field. Alias fields are used to streamline file maintenance; force fully keyed queries, such as those in the Incident Management and Service Desk applications; and facilitate virtual joining. Alias fields are only supported for scalar fields of the following data types: number, character, date/time, logical. The functionality is not designed to work for other data types like arrays and structures.
If regular purge and archive tasks are performed on files with different field names for the search criteria,
such as close.time in the problem and probsummary files, msg.time in the msglog file, and evtime in the eventin file,
you can build an alias in each file called archive.time and then perform all archive activity based on archive.time without regard to the file name.
In Service Desk and Incident Management, alias keys are used to ensure that a fully keyed query is performed each time an argument is entered from a record list. For more information see the Incident Management Help.
Source fields are defined as an alias when they must be defined as both a normal link and a virtual join; and the target file or field is different. For example, in the devicepc database dictionary record and the device.pc format and link records, the vj.logical.name field is the alias of the logical.name field.
Related topics
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 an alias field
Add a field to an existing database dictionary record
Create an active database dictionary record
