Database View not displaying records but shows Count
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-02-2022 12:37 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2023 09:46 AM
For fellow Debuggers out there and for my future self.
In a scenario, where you create a Database View with specific View Fields, and one of the View Fields happens to be of Document ID type, do remember to include the "Dependent on field" field in the View Fields. It fixed the exact same issue I had. For the example above, most probably, the Source table field is missing from View Fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-14-2025 04:40 PM
Is the resolved? If yes, please provide the workaround if possible. Thank You!
