Display name is not showing in the reference field

[Poorva Bhawsar]

Hi Community,

I have a field which is a reference field. I want to show only specific group members in the reference field for a catalog item.

I am using sys_user_grmember table for this and added simple reference qualifiers as user.active is true, group is xyz but still its showing sys id in the look up list of that field. I want to show the display name of the users which belongs to this group in this field.

Thanks,

Poorva Bhawsar

[Sagar Pagar]

Hi @Poorva Bhawsar,

The display check box is false for all the columns of Group membership [sys_user_grmember] table. Hence, it is showing sys_id.

Make the display check box for your required field (User). It is how the user names as display value.

Thanks,

Sagar Pagar

[Poorva Bhawsar]

I tried this already but still it was showing me sys ids only.

[Service_RNow]

Hi @Poorva Bhawsar 

follow this article it will be helpful

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0693859

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Poorva Bhawsar]

I already made user field display = true, but still sys ids are showing inside this look up field.