Still getting SYS_ID instead of Display value in Reference

Richard P
Mega Guru

Hi, I have created a new table. only 2 fields for a reference field. its not extended from any other table.

however when clicking on the lookup magnifier, it shows the sys_id values

I went into <system Definition> <Dictionary> and on the table I set the friendly string name to true

find_real_file.png

but still I only get the sys_id on lookup?

what else do I need to do?
find_real_file.png

7 REPLIES 7

Shahed Shah1
Tera Guru

Hi Richard



I do hope you were able to resolve this. If not, I do have a quick question: Does it extend another table?



If there is an extension hierarchy and you have a display value set for another (or plenty more) tables in between, including the base table, this could happen. To rectify that or to show the correct display value for that child table then you would want to create a Dictionary Override on the base table.



Another question is: is this is a new table or an existing one where the issue just started happening?



Not sure if it helps, but there's a KB out there for general knowledge about the Display Value: https://hi.service-now.com/kb_view.do?sysparm_article=KB0563369



Let me know how it goes or if you want to raise an Incident with Customer Support to have a look at it.



Regards


Callum Ridley1
Tera Guru

Hi Richard,



Not sure if you got this resolved or not but I think I might have a solution for you. It is possible to customise the view that you get in lookups and here is how:



You will want to go to the following url (adding in your instance name of course)



https://{instance name}.service-now.com/u_local_authorities_list.do?sysparm_view=sys_ref_list



That bit at the end is the important part, once the list loads you will be viewing it in "Lookup mode".



Once you are there you can use the usual method of configuring a list view by right clicking on one of column headers



find_real_file.png



Hope that helps



Callum


vipinvenugo
Tera Contributor

This helps....Thanks 🙂