Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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

Go to solution
Arjun Reddy Yer
Mega Sage

3 weeks ago

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
  • 532 Views
1 ACCEPTED SOLUTION

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

3 weeks ago

@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

3 weeks ago

tried that also it's not working

0 Helpfuls