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 Management2017.11

Administer > Database administration > Data persistence > Data maps > Alternatives to data maps

Alternatives to data maps

Data maps are an optional administration feature that you can use as part of the health and maintenance of your system to identify related records to purge or archive. In addition to data mapping, the following table shows other methods to purge and archive records.

Feature	Description	Differences from data mapping
Unload script utility	Unload records from multiple tables using saved queries.	No restrictions on record queries (data map queries must identify related records). Save multiple queries as one script record (data maps can support only one type of query for each record). List forms that you want to protect from purging (data maps can only purge records).
Entity relationship diagram definition (Erddef)	Define joins by entity relationships.	Define multiple joins (Each data map record can only define one join). Not integrated with the purge/archive function. Cascading deletion of related records (data mapping can only delete records as part of a purge process).

Send Help Center feedback