Performe the mass update procedure for existing records

To perform the Mass Update procedure for the existing records,

Select Menu Navigation > Change Management > Search Changes.
Click Search to display a list of change records.
Select the records you want to update.
Perform the Mass Update procedure:
1. Click Mass Update in the toolbar to start updating the listed records.
  
  Database Manager displays the initial form again, but with different options (buttons).
2. Do not specify values in any field. Click Complex Update.
  
  Database Manager displays the Instructions screen.
3. Type the following expression in the Instructions for action on EACH RECORD input field:
```
record.url in $file=jscall("urlCreator.getURLFromQuery","cm3r","number=\"" + number in $file + "\"","Change number " + number in $file)
```
Click Execute.

For each record updated, this step sets the record.url field based on the Web server URL entered in System Information Record. Then this step returns terminal control to you and displays the following message:
```
<n> records updated in the cm3r file.
```
where <n> is the number of records updated.
Once the Mass Update procedure is complete, confirm that the record.url field is populated for the existing Change tickets.
(Optional) To browse directly from the Web server using a URL that includes a ticket ID, disable the querySecurity parameter by using the instructions in the following Service Manager Help topic:

"Web parameter: sc.querySecurity"
(Optional) Add the following line to the conversion script file in OpenText PPM for converting Service Manager changes to OpenText PPM requests:
```
ppmRFC.addURLReference(serviceManagerRFC.get ("record.url"), <display text for URL reference>);
```
where <display text for URL reference> represents the text to be displayed for the link to the URL.

For information about copying the sample conversion file provided with OpenText Application Quality Management and revising the copy, see Configuring the Service Manager Adapter Converter Property (Script).

For information about the addURLReference function, see ppmRFC Object.