Records are not populating in Database view only few records visible not all the records

[Arjun Reddy Yer]

required help @Vasantharajan N  @Ankur Bawiskar 

As I created a database view for the mentioned tables.

1.) interaction_related_record

2.) sn_customerservice_case_its

Unable to view all the records in those 2 tables

Database View:

Records visible at present:

Records of interaction_related_record table:

Records of sn_customerservice_case_its Table:

[RaghavSh]

@Arjun Reddy Yer In your database view (view tables list) , mark the left join as "true".

You will get the left join option in "view table" list from gear icon.

Please mark the answer correct/helpful accordingly.

[Arjun Reddy Yer]

unable to understand can you please share a sample one

[RaghavSh]

In your view tables, you have defined WHERE clause. 
You also have a left join field there, you need to mark that as true.

Please mark the answer correct/helpful accordingly.

[Arjun Reddy Yer]

It's not showing even though I had selected in Personalize List Columns

[Brian Lancaster]

If not all the cases have a interaction that would not show up in the view. You could make them show up by setting left join to true. You will have to add it to the list layout of your database view were you see the where clause. You may also have to reverse the where clause meaning changing it to incdb_document_id=itsdb_sys_id.