If a table uses a reference field as a display value and that referenced field also uses a reference field as a display value, these values will display as sys_ids in a list view when the list is sorted by that field.
Steps to Reproduce
Create a table called testtable1.
For more information, see the product documentation topic Create a table.
Create a reference field to cmn_location on testtable1 and set it as the table's display value.
For more information, see the product documentation topic Add a reference field.
Create a few records on testtable1.
Create a table called testtable2.
Create a reference field to testtable1 and set this as the table's display value.
Create a few records on testtable2.
Open a list of testtable2 records and sort by the reference field created on testtable1.
Note that the values display as sys_ids in list view.
This issue is fixed in Madrid.
Related Problem: PRB632458