Sys id in List view issue

maboopathi · 2 weeks ago

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?

Tanushree Maiti · 2 weeks ago

Hi @maboopathi

1) The field pointing to the product might not have a primary display value assigned in the dictionary.

Navigate to the table that holds the product information (in Your target table i.e enhanceent).
Right-click the field label on the form and select Personalize Dictionary.
Check the Display box so that it is set to true. (Note: Only one field per table can have the Display flag set to true).
Save the record

2) If the display name works on the form but shows as a sys_id in the lookup list, you will need to modify the view specifically assigned to references.

In the application navigator, search for and select System UI > Views.
Search for and select the view named sys_ref_list.
Under the Lists tab, find and open the record for your table.
Under related lists, find List Elements and edit/add the fields you want to display

3) Clear the instance cache by typing cache.do in your application navigator filter and enter

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti

View solution in original post

palanikumar · 2 weeks ago

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.

Thank you,
Palani

GlideFather · 2 weeks ago

ahoy @maboopathi,

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

_____
A community that tolerates cheaters and ignores collusion isn't a community . RIP

maboopathi · 2 weeks ago

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 · 2 weeks ago

@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! 🙏

Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader