List field displaying sys_id rather than name after being saved

Sam Ogden · ‎07-07-2017

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

Chuck Tomasi · ‎07-17-2017

Sorry Sam. Mistake on my part. Go to the script include and change the line:

list.push(grm.getValue('sys_id'));

to

list.push(grm.getValue('user'));

The list was creating a bad list of sys_ids.

View solution in original post

Sam Ogden · ‎10-13-2017

Hi Chuck,

Just an update on this from a while ago. Got a good response from the Hi ticket. The issue is a known error under log PRB645057:

If a glide.list field created on one instance is transferred via Update Set to another instance, its sys_storage_alias record is not pointing to the correct database field. Instead of pointing to a 'medium' text field it will be pointing to a 'varchar' field. This field now allows only one sys_id to be stored, therefore adding multiple items to the list is not possible.

Servicenow have performed a change on our TEST instance and this has solved the issue. Just working with them now to get this into production.

Would just like to say thanks once again for all your help on this post over the last couple of months.

Thanks

Sam

Chuck Tomasi · ‎10-13-2017

Hi Sam. Thanks for the follow up. Glad you got something going on this. Sorry for the troubles it may have caused in the interim.