[Rest API] - Sort parameter not working for Date Fieldtype

Support
1

Hi,

I struggled a lot to understand the sorting for rest api, and after some testing found that the date field type is not sorting.

Test condition,
i have a test collection with just one field Date of Fieldtype date,
and have these four dates, 2019-10-18, 2019-06-18, 2019-02-20, 2019-06-21
my request url
/api/collections/get/test1?sort[date]=-1&token=account-xxxx

But the response order is not sorted, below is the order i received

  1. 2019-10-18,
  2. 2019-06-18
  3. 2019-02-20
  4. 2019-06-21

Either the sort api is not working or there is some default sort, which am not able to figure out.
Although i did find that Text Fieldtype sorting works, can anybody help me here please?
3.

2

I can’t reproduce it (SQLite). Sorting works on the collection entries view and with api calls.

Do you use MongoDB or SQLite?
Do you have any events (maybe in addons), that reorder the entries after they were found (collections.find.after)?