Database view filters

[AnthonyMull]

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

[Ankur Bawiskar]

@AnthonyMull 

I agree with @Philippe Casidy 

check these out of the box database view "User Group Skills"

it joins your relevant tables

also check below

Reporting on users with roles in groups 

all users groups and roles in single report 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏