How to get the Group members Count on the Group table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2017 12:25 AM
Hi All,
I want to store group members count in group table through business rule, please refer below code i have written to get member count on string filed.
Below code is working when group details (i.e. description or any field) updated, so want to modify code without update (or) insert any details on group table, i want to store the count. is it possible if yes, please help.
Thanks,
Sravanthi

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2017 12:28 AM
Better to write BR on sys_user_grmember table so any update in this table will update that Group Count value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2017 03:27 AM
Hi Sravanthi,
Better have a query business rule to store the values which would not require you to update/insert values inorder to get the desired result.
Let me know if this was helpful/correct
Have a lovely day ahead
Regards,
Divya Mishra

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2017 03:55 AM
Is the script not working? Alternatively, it would be better for you to use GlideAggregate instead of gliderecord.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2017 04:41 AM
Hi All,
On sys_user_grmember table , how we can go ahead and proceed with business rule. pleae provide the sample code for the same.