Variable type 'Lookup Select Box' display value is sys_id not name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-15-2017 08:22 AM
I have a variable with a type 'Lookup Select Box'. Which is a reference to the sys_user_grmember table. When choosing an option, it displays the users name, once the request has been submitted, it shows the sys_id in the variable. See screen shots.
When requesting something:
Once its been requested:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-15-2017 11:50 AM
Hi R Jan,
Which field is display=true on sys_user_grmember table. if no field is display=true then it will show sys_id in the lookup field
Have a particular field as display=true and then check the lookup field what it shows.
Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-15-2017 11:55 AM
Hi,
Check for display value for sys_user_grmember table. Make sure you have display value set to User or Group as required & no other field on the table has dictionary override marked as true.
Also, check for dictionary override by looking at some tabs below the same form.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-15-2017 11:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-18-2017 01:25 AM