User Name not being displayed in the "Users" Select box in User criteria page.

Chitra23
Tera Contributor

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.

8 REPLIES 8

Ankur Bawiskar
Tera Patron
Tera Patron

@Chitra23 

that field refers to sys_user table

I didn't get what is vm_Vdr_Contact

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Ankur,

 

vm_Vdr_Contact is a child table of Sys_user table. It is used to store vendor contacts.

@Chitra23 

as an admin are you able to select users from that child table?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@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.