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
03-02-2022 01:33 AM
It is not showing any Security constraint error also, please suggest.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2022 01:46 AM
Make sure to remove view fields. It worked for me.
Please mark it as helpful! If it works with you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2022 01:48 AM
Hi Bhuvana,
That rally helped!, Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2023 11:35 PM
I am facing this issue aswell, how to remove view fields?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-02-2022 01:54 AM
Hi Mrman,
This happened with me also and it was an issue with the Where clause, Please check your queries again and correct it. If it's because of restrictions due to ACL, a message will be displayed in the bottom.
