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]

Can you try changing the order of your 2 table and query in interaction related list table as:

incdb_document_id=itsdb_sys_id

Please mark the answer correct/helpful accordingly.

[Arjun Reddy Yer]

not working after changing the order

[RaghavSh · Accepted solution]

@Arjun Reddy Yer use below  where clause in interaction related list table (incdb_document_id=itsdb_sys_id), it should work.

Please mark the answer correct/helpful accordingly.

[Arjun Reddy Yer]

still same count no change in the records visible count