kobotoolbox / kobocat

Our (backend) server for providing blank forms to Collect and Enketo and for receiving and storing submissions.
BSD 2-Clause "Simplified" License
117 stars 127 forks source link

Sorting issue in fetch data api #875

Open Ishankoradia opened 1 year ago

Ishankoradia commented 1 year ago

We are trying to fetch records of a kobo form using the following query parameters as follows :

Screenshot 2023-05-03 at 12 28 25 PM

The form has close 4,00,000 records.

The following server error is seen up when accessing some of the pages of the records.

Screenshot 2023-05-03 at 12 26 51 PM

The error shows only when we query on "endtime". We have also checked the data export and endtime field for all the records have data in a consistent format.