Database view not showing correct records

[Tarun Kumar10]

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]

Hello there,

have you looked at this article?

Add a table to the database view

Your where clause looks wrong.

Regards, Ivan

[Tarun Kumar10]

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]

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.

[Tarun Kumar10]

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