Catch up wih the Appery.io community on our forum. Here you'll find information on the lastest questions and issues Appery.io developers are discussing.
https://forum.appery.io/
Hi!
I wanted to make query to the default column '_createdAt', but this doesn't work - DB returns just blank info. If i create field 'Date' with date type and then populate it with absolutely similar information, then do the query - it works ok.
So the question is - why i can't query '_createdAt' field?
Hi,
Please show us your query parameters.
doesn't work:
{"_createdAt" : "2014-01-03 12:51:49.725"}
works:
{"taskDate" : "2014-01-03 12:51:49.725"}
of course in both rows - same values - for testing purposes.
This should work:
pre
{"_createdAt":{"$gte":{"$date":"2013-05-11T15:10:39.376Z"},"$lte":{"$date":"2013-08-13T17:55:54.129Z"}}}
/pre
Igor, sorry, but this doesn't work:
{"_createdAt":{"$gte":{"$date":"2014-01-03 11:49:46.172"},"$lte":{"$date":"2014-01-05 20:01:56.484"}}}
For this there are for sure DB entries:
For 2014-01-03 11:49:46.172;
Code: Select all
{
"_createdAt":"2014-01-03 11:49:46.172",
"_id":"52c6a3dae4b06de3a9a293c3",
"_updatedAt":"2014-01-04 18:37:12.004",
"inviteList":{
"invite":[
"John",
"Lisa"
],
"location":"Art Center"
},
"name":"Мирослав",
"subtask":{
"collName":"Dates",
"_id":"52c69e20e4b06de3a9a2923a"
},
"taskDate":"2014-01-01 00:00:00.000"
}, For 2014-01-05 20:01:56.484
{
"id":"52c9ba34e4b0d96a2c19cc04",
"name":"Григорий",
"createdAt":"2014-01-05 20:01:56.484",
"_updatedAt":"2014-01-05 20:01:56.484"
},
Let's see if query in this format will help. It works for me.
pre
{"_createdAt":{"$gte":{"$date":"2013-05-11T09:56:13.508Z"},"$lte":{"$date":"2013-05-11T09:56:26.888Z"}}}
/pre
Igor, in what format dates are stored in 'your' db? in 'my' db they are stored in this format: "2014-01-03 13:46:47.149".
Hello! Please try this way pre{"_createdAt":{"$date":"2013-11-14T22:35:05.293Z"}}/pre