Default language.

Using SQL commands to shorten the Request ID field


This section contains information about:

Only administrators running BMC Remedy AR System with an SQL database can update existing request ID field values by directly accessing the SQL database. The syntax for direct access is different for each SQL database that BMC Remedy AR System supports.

To use the methods described in this section, you must be familiar with basic commands in the SQL command interface. SQL commands bypass BMC Remedy AR System completely. If you bypass BMC Remedy AR System, verify that all data is valid when you are finished.

Tip

Create a practice table in your database and practice the commands you will issue to make sure that you are issuing the correct commands. Make sure you back up your database or all the relevant tables.

Note

When you change the length of the Request ID field in a database table, all related database tables, such as status history tables (H Tables), and Attachment tables (B Tables and BC Tables) must also be updated.

Important

Stop BMC Remedy AR System before you attempt any database modifications.

Finding the name of the table

Before you can shorten the request ID field value, you must find the table holding the form being changed.

To find the table name

  1. Find the correct schema ID for the form with the following query:
    Select SchemaId, name from arschema order by 2
     This query returns a list of schema IDs and associated form names.
  2. Find the correct field ID with the following query. (The example assumes that the schema ID is 43.)
    Select FieldId, FieldName from field where SchemaId = 43
     This query returns a list of field IDs and associated field names.
  3. Use the schema ID, field ID, and information in the following table to construct the table name.





 AR System table name constructs




Note

For T schemaID and B schemaID tables, the request ID column of the table is always named C1. For the H schemaID, T schemaIDC fieldID, and B schemaIDC fieldID tables, the Entry ID column is equivalent to the C1 column.

 

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