Displaying Group members count in the customized integer in groups

[Deepthi24]

Hi Team,

There is a requirement from client to display the count of the group members in a customized integer field in a individual group.

For example in a group I have created a field, the group members displaying in the group need to be displayed in that customized field. So, I need to create this count of members through the script from business rule.

Is any any possibility for doing this way? Can anyone please help me on this.

[Allen Andreas · Accepted solution]

Hello,

Yes, feel free to search the forums as this has been asked previously and there's been some great discussion regarding this that can help you.

You can create an "after" business rule on the group member table to get the count of users via GlideAggregate, for example, and then update the integer field on the group record.

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

[Deepthi24]

HI @Allen Andreas /Team,

I have gone through the forums and didn't found based on my scenario.

As I'm having time crunch, Could you please help me on this..

Thanks in advance,

Regards,

Deepthi. P

[Allen Andreas]

Hello,

We all have a time crunch, you aren't attempting it yourself and if you search the forums there are several posts about this, as I've mentioned above:

Examples:

https://community.servicenow.com/community?id=community_question&sys_id=b61987e1db5cdbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=621c8581db2edf0054250b55ca96...

https://community.servicenow.com/community?id=community_question&sys_id=ad4a87a9db5cdbc01dcaf3231f96...

There's 3 right there within 10 seconds of searching.

Using the forums and searching is far faster than waiting for someone to give you exact code. I even guided you with my reply above anyway.

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