Database view

BKash
Tera Contributor

‎02-06-2025 02:03 AM

I have a requirement to create a Multi table report for an engagement where the columns are from Test Plan and control table. I have no experience in how to create database view for reporting purpose. Kindly assist, thanks!

0 Helpfuls
  • 1,280 Views
6 REPLIES 6

BKash
Tera Contributor
In response to Ankur Bawiskar

‎02-06-2025 02:27 AM - edited ‎02-06-2025 02:27 AM

Hi @Ankur Bawiskar , I don't have much idea on this database views. For now, I have created a database view where I have added Test Plan and Control Table. Not sure how to proceed further. And this report should be created for an engagement so that it shows the Test Plan details from the Engagement. 
Test Plan has Control reference field on the form.

 

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron

‎02-06-2025 02:30 AM

Hi @BKash 

 

Now you can use that Database in the report. Create a report and under the table, you will select the database view name which you create.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************