About Database Views

bonsai
Mega Sage

10 hours ago

I'm using a database view.

The database view displays information from two custom tables.
I believe the database view's function is to display only records that meet the same criteria.
Is there a way to display all records from two tables in a single database view?

I've created a custom role for the custom table.
The operating user has requester privileges.

0 Helpfuls
  • 92 Views
3 REPLIES 3

Rohit Ladda
Tera Contributor

10 hours ago

Use "Left Join=True" on one of the table. Try changing the order and where clause based on your custom table design.

0 Helpfuls

bonsai
Mega Sage
In response to Rohit Ladda

9 hours ago

I tried it but it only shows one table record.

0 Helpfuls

Dr Atul G- LNG
Tera Patron

9 hours ago

https://www.servicenow.com/community/sysadmin-forum/i-want-to-display-two-table-data-in-one-list/m-p...

*************************************************************************************************************
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