Space banner


This documentation supports the 19.11 version of BMC Knowledge Management, which is available only to BMC Helix subscribers (SaaS).
To view an earlier version, select the version from the Product version menu.

Changing the database schema sort order

The Schema Sort form enables you to customize the sort order of BMC Remedy AR System forms for your database. This form is used primarily during installation to select the sort order of forms according to the kind of database that you have installed.


If you are using a Microsoft SQL Server or Sybase database, you do not need to perform this procedure; the BMC Remedy AR System database is installed ready to be used by these database types.

To customize the database sort order

  1. From the Application Administration Console, click the Custom Configuration tab.
  2. From the Application Settings list, choose Foundation > Advanced Options > System Configuration Settings - Application Database Sort Order, and then click Open. The Schema Sort form appears.
    Schema Sort form

  3. Search for all records. To do this, enter % without specifying any search criteria and click Search.
  4. Set the custom sort order options.


    The default sort order options can be used in most cases.

  5. In the Functions area, select the Sort Order Type. Select MSSQL, Sybase, Oracle, DB2, or Informix option.
  6. Click Modify All.
  7. In the message box that appears, click Yes to confirm.


    You will see the changed sort order after you restart BMC Remedy AR System server.

Was this page helpful? Yes No Submitting... Thank you