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/
I'm trying to build into my query to only return events greater than today's date. Obviously today is dynamic
If I hard code the date it works
{"Event_date":{"$gt":'2014-03-20'}}
but I don't know how to get it to work dynamically
this does not work
{"Event_date":{"$gt":$.datepicker("setDate", "0")}}
Hi Nikita,
I tried with the below in the 'where' part of the query but had no luck
var d = new Date();
d.setDate(d.getDate() + 0);
var dateStr = d.toISOString();
return '{"EventStartDate":{"$gte":"'+ dateStr +'"}}';
I'm not sure if I'm even headed in the right direction here and would appreciate some more assistance.
thanks
Hi,
Lets see if this code help:
pre
code
var d = new Date();
d.setDate(d.getDate());
var dateStr = d.toISOString();
return '{"_createdAt":{"$gte":{"$date":"'+ dateStr +'"}}}';
/code
/pre
You can check service request/response is correct in browser console network tab.
Could you post app publick link?
Could you also tell us the steps how to reproduce this?
Sorry, from landing screen - upcoming events - search with QLD as the selected option. It should then give back a list and exclude any before today
Where did you add this code?
You should add it on your datasource-request tab-where clause-add JS.
Sorry I had added it into the wrong place.
i have placed it there now and this is the message under the console
Failed to load resource: the server responded with a status of 400 (Bad Request) https://api.appery.io/rest/1/db/colle...