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

Go to solution
Arjun Reddy Yer
Mega Sage

‎11-06-2025 08:40 AM

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:

 

ArjunReddyYer_0-1762445149066.png

ArjunReddyYer_1-1762445203374.png

ArjunReddyYer_2-1762445381277.png

 

Records visible at present:

ArjunReddyYer_4-1762445794825.png

 

Records of interaction_related_record table:

ArjunReddyYer_5-1762446161458.png

Records of sn_customerservice_case_its Table:

ArjunReddyYer_6-1762446695021.png

 

0 Helpfuls
  • 736 Views
1 ACCEPTED SOLUTION

Go to solution
RaghavSh
Mega Patron
In response to Arjun Reddy Yer

‎11-06-2025 08:58 AM

@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.


Raghav
MVP 2023
LinkedIn

View solution in original post

10 REPLIES 10

Go to solution
Arjun Reddy Yer
Mega Sage
In response to Brian Lancaster

‎11-06-2025 08:53 AM

tried that also it's not working

0 Helpfuls