From our main database, I attempted to extract all records collected this month using an SQL query. However, the query returns only 10 rows, even though the front end shows at least 74 completed surveys. I used the following SQL query for version 3 of our survey:
SELECT *
FROM “hq_fhp_f89ac00f-55a3-4615-b899-9ceab7719bd5”.“FHP_ODISHAP$3”
WHERE agri_month = ‘May’;
Could you please help me identify what might be causing this issue?