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.41

Administer > Database Administration > Data persistence > Exporting records > Export selected records from a table using an export descriptor record

Export selected records from a table using an export descriptor record

Applies to User Roles:

System Administrator

To export selected records from a table using an export descriptor record:

Click Tailoring > Database Manager.
Type the form or table name that contains the records to unload.
Select the Administration Mode option.

Note: You must select this option to ensure that HPE Service Manager displays the unload options in the target form.
Click Search.
Select the form used to search for records. Do not type or select any search criteria from this form.
Click More or the More Actions icon, and then select Export/Unload.

Fill in the following fields.

Field	Description
Field Name	Type the name of the field containing the selection criteria.
Field Values	Type a unique value for each record unloaded from the Field Name.

Click Unl Records.
Service Manager displays a record list of the records you selected.
From the record list, select the form, click More or the More Actions icon, and then select Mass Unload.

Fill in the following fields.

Field	Description
External File Name	Type the name and path of the destination file to contain the record list. By default, this file is located in the RUN folder of the Service Manager server.
Member	This field is obsolete.
Unload Type	Select the operating system file type to use for the external file.
Append to File	Select this option to add records to the end of an external file of the same name. If a external file of the same name does not exist, Service Manager creates a new file. If this field is cleared, then Service Manager overwrites any existing file of the same name.
Use Data Map	Select this option to use a pre-defined data map when unloading the selected records. Using a data map may result in Service Manager unloading more records than you originally selected to unload.
Prompt for Data Map	Select this option to enable a confirmation message to use a data map for each record unloaded. This option is only valid if the Use Data Map option is also enabled.
Suppress Messages	Select this option to hide all messages that the unload process generates.
Export Mode — Formatted Text	Select this option to save the external file using an export descriptor record. This format is intended for export to other applications.
Form Name	Type the name of the export descriptor record to use. This option is only valid with the Formatted Text option is selected. If the export descriptor record does not already exist, Service Manager prompts you to create it.

Click Export Ext.
If Service Manager displays a list of existing export descriptor records, select the export descriptor record to use.
Do one of the following:
- To change the export descriptor record, click Edit Record.
- To export the record, click Export.
  Service Manager saves the select records to an external file.