Closed kelvin-muchiri closed 2 months ago
The $or filter does not work for datetime meta data. Filtering by _submission_time, _date_modified, and _last_edited does not work.
_submission_time
_date_modified
_last_edited
Filtering data by or should work for meta data fields
or
Try filtering by or clause on endpoint api/v1/data/<form_id>?query={"$or": [{"_submission_time":{"$gte": "2020-01-01", "$lte": "2020-08-31"}}, {"_last_edited":{"$gte": "2020-01-01", "$lte": "2020-08-31"}}]}
api/v1/data/<form_id>?query={"$or": [{"_submission_time":{"$gte": "2020-01-01", "$lte": "2020-08-31"}}, {"_last_edited":{"$gte": "2020-01-01", "$lte": "2020-08-31"}}]}
Environmental Information
Problem description
The $or filter does not work for datetime meta data. Filtering by
_submission_time,_date_modified, and_last_editeddoes not work.Expected behavior
Filtering data by
orshould work for meta data fieldsSteps to reproduce the behavior
Try filtering by
orclause on endpointapi/v1/data/<form_id>?query={"$or": [{"_submission_time":{"$gte": "2020-01-01", "$lte": "2020-08-31"}}, {"_last_edited":{"$gte": "2020-01-01", "$lte": "2020-08-31"}}]}