Symptoms

Reference field on table shows sys_id instead on Display value for the table

Release

All Supported

Cause

The reference lists use the "sys_ref_list" view and it needs to be configured to show the correct columns.

Resolution

1. Navigate to System UI > Views.
2. Search and select sys_ref_list
3. In the "List" related list, search for the table you are referencing and open the record
4. Go to related lists and locate the "List Elements" related list
5. The elements are the columns that are displayed on the list when you click on the reference icon. You will need to add/remove as desired
6. To add the desired column to the list, click new or edit an existing record
7. The "Element" field value should be set to the name of the desired field. For example, if you are referencing sys_user table, you can set the user_name field as one of the columns.