Changing Request ID field values to a new format

You might want to change the values of Request ID fields for your AR System requests for the following reasons:

  • Consistency—All the Request ID field values for a form follow the same format. If the format changes, all the requests change to match the format.
  • Design—Your AR System design changed, and this design references the new format of the Request ID field. Usually, the length of the field changes from the default 15 to something shorter, and you must eliminate the extra leading zeros.

You can use either of the following methods to update Request ID field values:

After implementing one of those methods, see Updating-the-Request-ID-field-in-other-AR-System-tables.

Warning

Before updating field values or tables, back up your database to make sure your original data is saved if a failure occurs during the update.

For more information, see the following topics:

Action

Reference

Learn how to change the Request ID field by editing a .arx file.

Learn how to shorten or lengthen the Request ID field by directly accessing the SQL database.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*