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 |
|
Create data maps to related records
Applies to User Roles:
System Administrator
You can create data maps to related records across Service Manager tables to use with the purge and archive functions. The purpose of data maps is to identify related records of the records you select to purge or archive. All data maps use the same basic structure to search tables and fields for related records.
To create data maps to related records:
- Create one Type 0 data map record for each table to purge or archive.
The Type 0 data map record typically identifies the primary key field of the table.
Type 0 data map records are equivalent to the following SQL query:
SELECT <fieldname> FROM <filename> WHERE <fieldname>=<Value in Map Query> - Create one Type 1 data map record for each join field to query for related records.
The Type 1 data map record uses only the join field to search for related records in the external file.
- To specify additional selection criteria of records from the primary table, you can add a Map Query, which creates a Type 2 data map record.
- To specify additional selection criteria for records in the external file, you can add an override query in the Override Qry field. Because this query overrides the field listed in the Field Name field, you must include the join field within this query.
Type 1 data map records are equivalent to the following SQL query:
SELECT [<override_qry> | <fieldname>] FROM <queryfile> WHERE <fieldname>=<value in filename> - Create one Type 2 data map record for each join field that has additional selection criteria for records from the primary table.
Type 2 data map records use the Map Query field in addition to the Field Name field to identify records from the primary table.
Type 2 data map records are equivalent to the following SQL query:
SELECT [<override_qry> | <fieldname>] FROM <queryfile> WHERE <fieldname>=<Value in filename> and <Value in Map Query>
Related topics
Data maps
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
Delete a data map record
Update a data map record
View a data map record
