In a service, I'm trying to get from a collection all the records updated less than 5 minutes ago, using the _createdAt column in the 'where' clause. I've tried all sort of combinations of date formats and everything I could read in this forum and the docs. What is the right syntax?
The docs say:
{ "time" : {"$lt" :"2014-01-17 00:00:00.000"} }
But this doesn't work (test successful but empty answer (not even [ ]):
{ "_updatedAt" : { "$gt" :"2013-12-01 00:00:00.000"} }
Thanks
Hhi Chris,
The syntax is correct, how do you map the response? Please show us a screen shot.
Hi Alena,
I'm not even mapping it yet. Just testing it and the answer is empty.
And it works without the where clause:
Chris, we'll test more and update as soon as possible.
Chris,
The syntax should be as follows:
pre{"_updatedAt":{"$gt":{"$date":"2013-12-01T00:00:00.000Z"}}}
/pre
Note, there should be ISO date format:
T - before
Z - after
We'll update tutorials.
It works, thanks.
I'm using server code and trying to query Files collection based on _createAt column using below code.
The issue that I'm facing is that I'm getting ALL records and not based on the query parameter date.
Code:
var XHRResponse = XHR.send("GET", "https://api.appery.io/rest/1/db/files", {
"headers": {
"X-Appery-Database-Id": dbId,
"X-Appery-Master-Key": dbMasterKey
},
"parameters": {
"where": '{"_createdAt":{"$gt":{"$date":"' + moment().zone("+02:00").add('days', -1).format('YYYY-MM-DD hh:mm:ss.SSS') + '"}}}'
}
});
*Even if I set static date I'm getting ALL records:
"where": '{"_createdAt":{"$gt":{"$date":"2014-12-24 04:21:00.256"}}}'
Can you tell me why?
Hi Yaniv,
Unfortunatly file api not not supports searching.
Details: http://devcenter.appery.io/documentat...
But you can search it with server script by field you need.
Regards.
Can you explain T and Z a bit here?
You are saying the _updateAt had to be before 2013-12-01 but at any time of the day?
Whereas "2013-12-01T12:00:00.000Z"
would be on any day before 2013-12-01 but after noon?
Hello,
"2013-12-01T12:00:00.000Z" will indicate the start of the time interval.
If a time zone designator is required, it follows the combined date and time. For example, "2007-04-05T14:30Z" or "2007-04-05T12:30-02:00".
If the time is in UTC, add a Z directly after the time without a space. Z is the zone designator for the zero UTC offset. "09:30 UTC" is therefore represented as "09:30Z" or "0930Z". "14:45:15 UTC" would be "14:45:15Z" or "144515Z".
A single point in time can be represented by concatenating a complete date expression, the letter T as a delimiter, and a valid time expression. For example, "2007-04-05T14:30".