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 |
|
- Database administration
System Definition
The System Definition section of the System Navigator is an administrative tool that enables you to view and modify system tables and their components:
- Fields
- Keys
- Links
- Forms
- Records
You can use the System Definition section if you have the Admin plug-in installed and the SysAdmin capability word enabled in your user profile. If you have SysAdmin rights, but the Admin plug-in is not installed, you can view the System Definition section but you cannot change it.
Administrators can do the following:
- View, add, change, or delete forms, links, records, triggers, and Data Policy records.
- Use the System Definition utility to add help or create an alias for any field.
- View, add, change, or delete database dictionary definitions.
- View, add, change, or delete SQL mappings to a back-end RDBMS.
- Open, reset, regenerate, and copy database dictionary definitions.
- Add, change, copy, and delete keys and fields.
- Count the number of records in logical tables
Each time you right-click a node in the System Definition section, the System Navigator displays a Context menu of available actions.
System Definition utility
The System Definition utility is a graphic view of existing table elements and properties and a quick way to define new tables. It enables you to accomplish the tasks traditionally handled by the database dictionary utility. The System Definition utility has two tabs: tables and fields. Service Manager displays SQL mapping information only when mapping information is available. Each time you double-click any table in the System Definition area of the System Navigator, the System Definition utility displays the Table tab first. You can access the other tabs by clicking the labeled tabs or links in the Editor.
If you change a table element, an asterisk marks the table and the element in the System Navigator until you click Save.
Access the System Definition utility
Applies to User Roles:
System Administrator
To access the System Definition utility:
- From the System Navigator, click System Definition.
-
Expand the name of any table in the record list.
Note: You can type the first letter of a table name to jump to that alphabetic section. For example, type
o
to jump to the oncall table.
Related topics
Editing System Definition nodes