Page 1 of 1
Query on _createdDate does not return proper result
Posted: Mon Mar 24, 2014 6:22 pm
by jaydatt
Hello Everyone,
I am using following query in order to fetch the latest record comparing _createdDate greater than last sync time. However manytime if I've 5 records with the same timestamp but appery.io request only returns two or three records.
I am using this query.
https://api.appery.io/rest/1/db/colle...
Please help.
Query on _createdDate does not return proper result
Posted: Mon Mar 24, 2014 6:53 pm
by Nikita
Hello,
Please use Import database service:
http://docs.appery.io/documentation/b...
and then add parameter "where".
Query on _createdDate does not return proper result
Posted: Mon Mar 24, 2014 6:56 pm
by jaydatt
@Nikita,
Well, actually we are trying to sync the records to other application using appery.io APIs.
Query on _createdDate does not return proper result
Posted: Mon Mar 24, 2014 8:15 pm
by Nikita
Hi,
Your query is a bit wrong. Parameter "where" should look like this:
{"createdAt":{"$gt":"2014-03-24T17:50:07.891Z"}}
Query on _createdDate does not return proper result
Posted: Tue Mar 25, 2014 3:24 pm
by jaydatt
Hi Nikita,
we tried changing our query with the above query, but changing this returns nothing. our original query atleast returns us some rows. But the above change is not working as it does return nothing(it returns []).
Query on _createdDate does not return proper result
Posted: Tue Mar 25, 2014 6:21 pm
by Nikita
Hi,
Are you sure, that there are in DB 5 such records. Could you provide a screenshot?