Database view filters

AnthonyMull
Tera Contributor

3 hours ago

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

0 Helpfuls
  • 145 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron

4m ago

Hi @AnthonyMull 

 

Yes, that approach is correct. A Database View is a good place to start in this case. When you create the Database View and add the required tables as sources, you can apply filters before creating the report. This is similar to setting predefined conditions so that the report only works with the data you need.

DrAtulGLNG_0-1780867559386.png

 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls