script include to show group members using sys_user table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-24-2020 01:31 AM
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.
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-24-2020 01:38 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-24-2020 02:42 AM
we cant make any changes on the oob table. as per the practices in our project
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-24-2020 03:19 AM
In that case you need to return user or user.name instaed of sys_id from script include.
Raghav
MVP 2023