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 under review. To receive notifications when more information is available, subscribe to this Known Error article by clicking the Subscribe button at the top right of the article. If you are able to upgrade, review the Fixed In field to determine whether any versions have a permanent fix.
Related Problem: PRB632458