Changing the database schema sort order
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
- From the Application Administration Console, click the Custom Configuration tab.
- 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
- Search for all records. To do this, enter % without specifying any search criteria and click Search.
Set the custom sort order options.
The default sort order options can be used in most cases.
- In the Functions area, select the Sort Order Type. Select MSSQL, Sybase, Oracle, DB2, or Informix option.
- Click Modify All.
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.