List Field Search showing Sys_ID instead of name

[Sam Ogden]

Hi all,

I've jus created a List field on our incident form.   This is a reference to the sys_user_grmember table with a simple filter of group is SM Managers.

When you type a name in the search it brings up the name in the dropdown:

But if you select the magnifying glass the view only shows the sys_id and not the names of the people:

I thought that this was to do with the display tick box not being checked on the user field of the sys_user_grmember table, so I have ticked this but it is still only displaying the sys_ID.   Any suggestions?

Thanks

[Anurag Tripathi]

Display field is usually the only thing. Can you confirm that sys_gre_member table khas a column with display checked(and only one column).

If yes then try to clear cache once by appending /cache.do to the instance url

<yourinstance>.service-now.com/cache.do

[Anurag Tripathi]

Also, mate whenever you post screens or something from the customer instance make sure you mask the url and anything else that might be 'private' to the company,. This might cause compliance issues.

[Sam Ogden]

Hi Anurag,

The sys_user_grmember table has two columns - Group and User

I have set the User column to display:

[Anurag Tripathi]

Hit the cache , i believe its a non prod instance so no harm trying.