Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Database view not showing correct records

Tarun Kumar10
Tera Contributor

‎01-08-2024 12:35 AM - edited ‎01-08-2024 12:44 AM

Hi,

 

We are creating a database with different 3 scoped custom tables, and they have nothing in common. 

 

We have created left join data base view with sys_id not null, however it shows extra and duplicate records and not the correct set of records.

TarunKumar10_0-1704703351981.png

 

Can someone help me here.

0 Helpfuls
  • 1,033 Views
6 REPLIES 6

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Tarun Kumar10

‎01-11-2024 12:59 AM

Hi @Tarun Kumar10 

 

Thanks for update, even you log a HI case. If i can still suggest

- Download the data from 2 tables and check manually, what you want to achieve, is any record there or not , which again guide you to correct the where clause.

 

Hope the spellings are correct in where clause ( Rare case but can be reason)

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

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

Vallabh Baradk2
Giga Guru

‎01-11-2024 01:04 AM

Hi @Tarun Kumar10 ,

 

If there is nothing common in the tables we can't make the database view . It will show duplicate records only.

 

Please mark the answer helpful or correct if it works for you.

 

Regards,

Vallabh

0 Helpfuls