User Name not being displayed in the "Users" Select box in User criteria page.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2023 09:45 PM
Hi,
I'm trying to add a user criteria in which I'm selecting a contact from "vm_Vdr_Contact" in the "Users" Selectbox in the User criteria page. I'm able to find and select the vendor contact using the magnifying glass in the users selectbox. However the name of the contact is not displayed in the selectbox. Only a blank line is seen.(refer the attached pic).
when I inspect the record in the browser developer tool, I can see the value field being populated with the sys_id of the contact. Only name is not being displayed.
I can see that the "vm_Vdr_Contact" table as an ACL for first name and last name fields. But my id has the roles mentioned in the ACL.
I have the following roles admin, vendor_reader.
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2023 10:10 PM
that field refers to sys_user table
I didn't get what is vm_Vdr_Contact
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2023 10:15 PM
Hi Ankur,
vm_Vdr_Contact is a child table of Sys_user table. It is used to store vendor contacts.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2023 10:29 PM
as an admin are you able to select users from that child table?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2023 10:33 PM
@Ankur Bawiskar Yes. I'm able to see the users from that table when i search for an user using the magnifying glass. The sys_id of that user is added as a value in the selectbox and i'm able to process the Sys_ids in the backend. The name is not just getting displayed in the select box.