jaydatt
Posts: 0
Joined: Tue Feb 11, 2014 7:23 pm

Query on _createdDate does not return proper result

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.

Nikita
Posts: 0
Joined: Fri Feb 28, 2014 4:02 pm

Query on _createdDate does not return proper result

Hello,

Please use Import database service:
http://docs.appery.io/documentation/b...
and then add parameter "where".

jaydatt
Posts: 0
Joined: Tue Feb 11, 2014 7:23 pm

Query on _createdDate does not return proper result

@Nikita,

Well, actually we are trying to sync the records to other application using appery.io APIs.

Nikita
Posts: 0
Joined: Fri Feb 28, 2014 4:02 pm

Query on _createdDate does not return proper result

Hi,

Your query is a bit wrong. Parameter "where" should look like this:
{"createdAt":{"$gt":"2014-03-24T17:50:07.891Z"}}

jaydatt
Posts: 0
Joined: Tue Feb 11, 2014 7:23 pm

Query on _createdDate does not return proper result

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 []).

Nikita
Posts: 0
Joined: Fri Feb 28, 2014 4:02 pm

Query on _createdDate does not return proper result

Hi,

Are you sure, that there are in DB 5 such records. Could you provide a screenshot?

Return to “Issues”