- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2022 10:16 PM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2022 11:37 PM
add this related list condition along with active is true and group members is 0 filter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2022 10:25 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2022 11:05 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2022 11:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2022 11:37 PM