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:


-- Go to User Preference Under User Administration 
-- Look for user preference with name: cmdb_ci.db.order and system=true. 
-- If you dont find existing record create new one, if you find existing record update the value as per your needs.
-- Create new user preference by clicking New Button 
-- Here are the details you will need to fill: 
Value: name 
System: Checked 
Type: String 
-- When you re-login again you will see order is changed:

Applicable Versions


Article Information

Last Updated:2019-05-21 11:40:54