The display values are not appearing.

AshutoshaP
Tera Contributor

Hi Guys,

I have created a custom table that contains three fields referencing three different tables. However, when I open records in this custom table, those fields are displaying the sys_id instead of the expected display values.

I have already checked and ensured that the Display property is selected in the Dictionary for the respective fields in all three referenced tables, but the display values are still not appearing.

Could you please help me understand what might be causing this issue?

3 ACCEPTED SOLUTIONS

@AshutoshaP 

So you click on the maginifying icon for Access name and then the windows opens up

There you are seeing sysId only in columns and not the System name?

if yes then configure the list layout when you click Magnifying icon and add System name there

Then when you click magnifying icon it will show System name

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

 

💡 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

View solution in original post

PoonkodiS
Giga Sage

@AshutoshaP 

PoonkodiS_0-1781179508442.png

PoonkodiS_1-1781179538417.png

system definition>dictionary

1.chose your reference table with coloumn label - name

View solution in original post

Teja R
Kilo Sage

Have you got the solution or You have Stuck any where

View solution in original post

17 REPLIES 17

ahoy @AshutoshaP 

GlideFather_0-1781177291106.png

From what you have shared, it works as it should ;))

 

your field is type of string (plain text), change it to reference and select the proper table. Example "Location" on Incident table - the field is referencing the [cmn_location] table...

_____
Answers generated by GlideFather. Check for accuracy.

@AshutoshaP 

So you click on the maginifying icon for Access name and then the windows opens up

There you are seeing sysId only in columns and not the System name?

if yes then configure the list layout when you click Magnifying icon and add System name there

Then when you click magnifying icon it will show System name

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

 

💡 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

Teja R
Kilo Sage

Hi @AshutoshaP ,

Is the sys_id showing when you click the magnifying glass, or after selecting the reference record?
can you provide the screen shot after selecting the reference records.

No , It showing when I click the magnifying glass.

Teja R
Kilo Sage

Hi  @AshutoshaP ,
If it is showing only after clicking on the magnifying glass then you need to go to the "sys_ui_list" table and filter the record.And then add the Fields you want to show in the List Elements related list.

TejaR_0-1781177268920.png

TejaR_1-1781177287113.png

 

 

 

 

If my response helped, please mark it as helpful and accept the solution.

 Thanks,
Teja.