Active groups with no members and Roles

[Ashik Suresh]

I wanted to filter out the active groups with no members and roles.

I navigated to sys_user_group and when i tried out the filters, i could get the active groups with no members. But i cant filter out the groups with no roles.

I tried the filter 'Group. Roles' is 'empty'. But not showing up the results.

Could anyone please help me?

[Voona Rohila]

Hi Ashik

How did you acheived the first one? where are you using this filters?

group roles and group members are stored in seperate tables.

Group Roles - sys_group_has_role, Group Members - sys_user_grmember

If you are using reports then you can use related list conditions to filter no members and no roles.

[Ashik Suresh]

The purpose of this is to create a report on Active groups with no members and roles. I navigated to 'sys_user_group' and done the following :

Here i couldnt mention roles as empty. If it could be done with a related list condition, could you pls show me

[Ashik Suresh]

The purpose of this is to create a report on Active groups with no members and roles. I navigated to 'sys_user_group' and done the following :

Here i couldnt mention roles as empty. If it could be done with a related list condition, could you pls show me

[Voona Rohila · Accepted solution]

add this related list condition along with active is true and group members is 0 filter