Database view not showing correct records

Tarun Kumar10 · ‎01-08-2024

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.

Can someone help me here.

Ivan Betev · ‎01-08-2024

Hello there,

have you looked at this article?

Add a table to the database view

Your where clause looks wrong.

Regards, Ivan

Tarun Kumar10 · ‎01-08-2024

Hi Ivan,

Thank you for your repose, yes I have to be referred to it earlier and tried with however didn't get correct result. I got 100's of unwanted record.

Dr Atul G- LNG · ‎01-08-2024

Hi @Tarun Kumar10

If I suggest

- Build DB on 2 tables first and check the results.

- Try to change order of tables and then check.

In short, break this in pieces and easy to debug.

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

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

Tarun Kumar10 · ‎01-11-2024

It didnt work with two tables as well, I have posted a question to HI support, awaiting the response.