Hi community
I would like to build a report based on the roles a user has and the type of the group the users are in.
I think I will use a database view, but I have 2 questions please.
1. Is database views the best approach here.
2. If using a database view, how can I filter the data on the view before building the report, for example if I join on the user sys_id of the both tables, how can I filter to say only show users that are active before the report
Thanks in advance
