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.
|A single word||
||Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".|
You can specify that the search results contain a specific phrase.
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.
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||
|A combination of search types||
- 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
- Renaming a database dictionary
- Resetting a database table
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,
close.time in the
msg.time in the msglog file, and
evtime in the
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.