Page 1 of 1

Distinct Query within date range.

Posted: Fri Nov 27, 2015 5:58 pm
by Joe Bohen

I am having a problem with a database query I have asked a question in this area before but have not been able to get this working fully, the query I am using is:

https://api.appery.io/rest/1/db/colle...? where={"_updatedAt":{"$gte":{"$date":"2015-11-26T00:00:00Z"},"$lt":{"$date":"2015-11-27T00:00:00Z"}}}

The query provides a result but it does not apply the date filter! Where is the problem in this query?


Distinct Query within date range.

Posted: Sun Nov 29, 2015 2:20 pm
by Alena Prykhodko

Hello,

Where do you run this query? Please show us screen shot.

If you try directly in Database query it works as expected for me.