script include to show group members using sys_user table

Karan31
Tera Contributor

Hi Team, I need to create a script include to show group members of a particular gruop in reference field.

I know that this is done using Group member table, but in my client instance Created on fielld is the display field on the table, so when i use group utils script include , it works but displays created on  timestamps rather than names or sysid.

& We cant change the display field.

 

 

3 REPLIES 3

RaghavSh
Kilo Patron

Set the display value of "sys_user_grmember" table to Name.

Open table "sys_user_grmember" select  field "user" and mark it as "Display =True"


Raghav
MVP 2023

Karan31
Tera Contributor

we cant make any changes on the oob table. as per the practices in our project

In that case you need to return user or user.name instaed of sys_id from script include.


Raghav
MVP 2023