How to sort reference variable on specific columns

This article will explain how to sort reference variable on specific column in Record Producer. Reference variable is referencing to other table, so you will need to sort the table column that is referenced variable.

For Example, on change_request form on clicking Configuration Item look up list, its sorted by Location, but you want to sort it on name:

Procedure

1. Go to User Preference Under User Administration
2. Look for user preference with name: cmdb_ci.db.order and system=true.
3. If you dont find existing record create new one, if you find existing record update the value as per your needs.
4. Create new user preference by clicking New:
   1. Name: cmdb_ci.db.order
   2. Value: name
   3. System: Checked
   4. Type: String