How to get the Group members Count on the Group table?

sravanthivaina1
Kilo Explorer

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.

BR when to run.PNGBR Script.PNG

Thanks,

Sravanthi

7 REPLIES 7

Deepak Kumar5
Kilo Sage

Better to write BR on sys_user_grmember table so any update in this table will update that Group Count value.


divya mishra
Tera Guru

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


Kalaiarasan Pus
Giga Sage

Is the script not working? Alternatively, it would be better for you to use GlideAggregate instead of gliderecord.


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.