List field displaying sys_id rather than name after being saved

[Sam Ogden]

Hi All,

We have created a list field on our incident table called u_escalated_to.. This is a reference to the sys_user_grmember table and has a simple filter of Group is SM Managers.

When you first select the name in the list it displays correctly.

Once you save the record it is displaying as the Sys_ID

Any suggestions on how to get it to retain the name rather than the sys_id?

Any help is greatly appreciated

Thanks

[Sam Ogden]

Hi Chuck,

Apologies on the delay of getting back to you, I was on annual leave fore the end of last week.

I've checked and the script includes and reference qual are the same between DEV and TEST.

I've checked and the target table (sys_user) has no display value set, but this is the same on my DEV instance too where this is working as expected:

DEV

TEST

Do you mean having read access to the u_escalated_to field?

Thanks

[Chuck Tomasi]

Hi Sam,

If it is working on dev and not on test, then it's important to try and track down the differences. Things to check:

• ACLs - on the fields and on the tables
• Table definitions
• Field definitions (which field is designated as the display=true field)
• Dictionary overrides on any fields related to the display value

[Sam Ogden]

HI Chuck,

I've just been having a look at this.   On the incident form we also have the Work Notes List and Watch List options.   These are both reference fields to the sys_user table, and in TEST these are displaying correctly, so I presume I can safely say that the table and field definitions and dictionary overrides must be ok, otherwise wouldn't I see the same issue on this list?

I am seeing this display issue even when I am trying to do the test as myself (with admin role) so would expect the ACLs to be ok, is there any way I can debug to try and pinpoint a bit easier where this field is going wrong?

Thanks once again for all your help.

[Chuck Tomasi]

HI Sam,

I don't have any ideas at this point. If nobody else has something to contribute here, I recommend reaching out to customer support. I'll be interested to hear what they have to say.

HI Service Portal - ServiceNow

Contact Support | ServiceNow

[Sam Ogden]

HI Chuck,

I raised a Hi Ticket yesterday and will update this post when I hear something back.

Thanks