Database View not displaying records but shows Count

[Mrman]

Hi ,

I am working on a database view joining the Assessment Metric result [asmt_metric_result] and Metric [asmt_metric] tables for creating report on survey responses submitted by users. 

The Database view list shows only one record but the count shows 37 . Please help me to find what is blocking the records to be displayed.

Below are screenshots of View tables added and the list view showing only 1 record but count as 37

[Ankur Bawiskar]

Hi,

Is this happening for admins or non-admins?

Did you check any ACLs on those tables are restricting?

Regards
Ankur

[Mrman]

@Ankur Bawiskar I am trying this as an 'admin' . I already checked ACL's on those view tables , Admin overrides is already selected on them. Please suggest.

[Mrman]

@Ankur Bawiskar I already enabled 'Debug security' and tested but nothing showed up .

[Ankur Bawiskar]

Strange.