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 |
|
- Data persistence
- Database dictionary
- Keys and indexes in Service Manager
- Data maps
- Exporting records
- Importing records
- Unload script utility
- Purging and archiving records
- Add, delete or update a master data record
- Database record auditing
- IR Expert
- Record retrieval
- Queries
- Database performance tuning
- Running the database maintenance utility
Data maps
Data maps are a means of identifying related records among separate tables in Service Manager. Service Manager applies data map queries to each record returned in a purge or archive selection query. For example, if during the purge and archive process you select 10 probsummary records, then Service Manager uses the probsummary data map to search for related records on each of the 10 records.
When you enable a data map, Service Manager returns a list of additional related records for each purge or archive record queried. Service Manager purges or archives these related records along with the original records you selected during the purge and archive process. For example, using a data map on 10 probsummary records may result in 30 actual records being purged or archived.
Note: Using data maps can greatly increase the number of records that you purge or archive. Since there is no limit on the number of data maps that you can define, there can potentially be a large number of mappings for any given table.
Tip: To prevent the accidental loss of substantial numbers of records, use the purge and archive function to save copies of your records to an external table before deleting them. This enables you to restore any records that you may have deleted accidentally.
By default, Service Manager has 155 pre-defined data mappings that you can use to purge or archive records and forms. These mappings contain the most commonly purged or exported records and tables. If you add custom tables and fields to your Service Manager system, you may want to create custom data mappings to purge or archive any related records based on these custom tables.
To create data mappings to related records, you must know the primary key fields and join fields used by your Service Manager tables. You must also know how to write Service Manager queries using escaped characters, special operators, and RAD variables.
Related topics
Alternatives to data maps
Types of data maps
Exporting records
Importing records
Purging and archiving records
Unload script utility
Master data records
Add a data map record
Create data maps to related records
Delete a data map record
Update a data map record
View a data map record