Sys id in List view issue

[maboopathi]

Hi all,

when I open enhancement table, in the list view I can see the sys id of the product instead of display name. I have attached the screenshot. How do I fix this?

[palanikumar]

Check whether those products are deleted from the products table. 

Normally reference field displays the display field of the referenced table. If the actual data is deleted then it shows the sys_id.

[GlideFather]

ahoy @maboopathi,

try to replace it with some other value, if it will change

[maboopathi]

It is an string field. Sorry but when I change it to reference field and give the table name, I can't change. I am getting type change error

[Ankur Bawiskar]

@maboopathi 

if it's a string field and storing sysId then

1) that field could be earlier a reference one and later changed to string

OR

2) some script is populating the sysId in that string field

Did you debug?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏