The display values are not appearing.

[AshutoshaP]

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?

[Ankur Bawiskar · Accepted solution]

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

[PoonkodiS · Accepted solution]

@AshutoshaP 

system definition>dictionary

1.chose your reference table with coloumn label - name

[AshutoshaP]

Hi Teja could you help me to understand how it will help to resolve my issue. 

[Teja R]

Simply open the sys_ui_list table and filter the table like (name : your table name and view : reference list)

In the List Elements Related list Click On new and add the backend name of the Column you want to show and give the Position and List ID (table name automatically populated).Save and Clear the browser Cache.

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

 Thanks,
Teja.

[PoonkodiS]

@AshutoshaP 

1.cache.do

2.If it not works, check the access

Can your user account actually read the column you marked as display? If your user role doesn't have security permission (ACLs) to read the "Name" field on that target table, ServiceNow will hide the text and show you the sys_id instead as a safety fallback.

I checked the caller id field of the incident table.It's referencing the sys_user table.

[PoonkodiS]

@AshutoshaP 

and also checks 

1. Right-click the field label of your custom form and choose Configure Dictionary.

2. Look at the Reference box.

3. Make sure the table selected there is the exact one containing your data.

[PoonkodiS · Accepted solution]

@AshutoshaP 

system definition>dictionary

1.chose your reference table with coloumn label - name