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 |
|
Add a data map record
Applies to User Roles:
System Administrator
To add a data map record:
- Click System Administration > Base System Configuration > Miscellaneous > DataMaps.
-
Fill in the following fields.
Field Description Desc Type a description of the data map record. Filename Type the name of the Service Manager table with the primary key field that you want to query. Service Manager purges or archives records from this table. This is a required field for all data map records. Type Service Manager automatically populates this field with the data map type 0, 1, or 2. Do not change the value of this field directly. Field Name Type the name of the primary key field for the table to create a Type 0 data map, or type the name of the join field to query for Type 1 and Type 2 data maps. This is a required field for all data map records. Array? Type true
or false to specify whether the join field to query is an array. By default, this field is false. Choose true if the data map is to check every element in the array for related records in the external file. This field is only for Type 1 data maps.Arrayed Structure? Type true
or false to specify whether the join field to query is an arrayed structure. By default, this field is false. Choose true if the data map is to check every element in the AS Field No. for related records in the external file. This field is only for Type 1 data maps.AS Field No Type the ID number of the join field to query in an Arrayed Structure. This ID number is defined in the dbdict. Map Query Type the query to identify source records in the primary table. Adding a query to this field makes the record a Type 0 or Type 2 data map, depending on the Query File value. You must write this query in the Service Manager query format, and you can use the following variables:
$umapdata — This variable stores the value of the Field Name field of the current record. For example, the Field Name was name, the value could be an operator such as System.Admin or a form name such as contacts depending on the table you are querying.
$umapfile — This variable reads the value of the Filename field in the purge or archive record.
$umap.modtime — This variable reads the value of the current modification time in the purge or archive record.
$umap.mod.date — This variable reads the value of the last modification date in the purge or archive record. If no value is listed, Service Manager displays the current date and time.
$acntr — This variables reads the value of the element in an array or array of structures in the purge or archive record.Query File Type the name of the external file to query for related records. Adding an entry to this field makes the record a Type 1 or Type 2 data map, depending on the Map Query value. Override Qry Type the query used to replace the Field Name to identify related records in the external file. If this field is blank, Service Manager uses the Field Name as the join field to query for related records. Adding an entry to this field makes the record a Type 1 or Type 2 data map, depending on the Map Query value. Map Cond Type true, false, or a Boolean expression that evaluates to true or false to identify when Service Manager should use this data map record. By default, this field is true meaning that Service Manager should use the data map in all conditions. Add to Map List Type true, false, or a Boolean expression that evaluates to true or false to identify when Service Manager should add an entry to the data map list. By default, this field is true meaning that Service Manager should always add an entry to the data map list..
- Click Add.
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
Create data maps to related records
Delete a data map record
Update a data map record
View a data map record