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	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.50

Administer > Database Administration > Data persistence > Data maps > Create data maps to related records

Create data maps to related records

Applies to User Roles:

System Administrator

You can create data maps to related records across HPE 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>

Send Help Center feedback