Dashboard - Which group does a user belong to?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2024 09:39 AM
I need to create a dashboard where I can filter all the users and see which groups they belong to.
Probably an "interactive filter" plus a report with the groups.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2024 10:10 AM
Hi,
You can create a report on sys_user_grmember table. Did you try and stuck at something?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2024 12:49 PM
Hi @afrpereira ,
You can create a simple list report of sys_user_grmember and afterwards add an interactive filter of the sys_user. Based on this, when you select a user, the list will be filtered to there respective groups.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2024 01:18 PM
Hi @afrpereira ,
You can create the report on sys_user_grmember
And then create the interactive filter it should work
If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!
Thanks & Regards,
Sumanth Meda