Data is not populating in database view

srivaniveeramol
Tera Contributor

Hi Everyone, 

 

I'm facing issue with database view 

 

I have 2 tables let say Table A and Table B 

 

In Table A, I have a field reference field let say - tableA.field1 which is having number field so we navigated like in database view is tableA_field1

 

In Table B, I have reference field let say field2 which is also a reference field in field2 we have one more reference field let say field1. So in database view where clause we added tableB_field2_field1

 

To match field1 in both the table 

 

But it is showing the count correctly but not data 

 

Please let me know where I'm doing wrong? 

3 REPLIES 3

akankshak15
Tera Guru

Hi @srivaniveeramol 

Did you find any solution for this ?

Bert_c1
Kilo Patron

post a screen shot of the database view. Then folks here can assist.

 

See: 10-tips-for-writing-a-quality-community-question

 

Thank you for your quick response. I got the solution for my issue.

issue was after the upgrade on reports some of field's data was not visible (where we have used databased view reports )So by enabling this system property glide.script.partial_record_materializer.enabled = true

Resolved the issue