Forum | Appery.io

Lets try to use return with some predefined values:
precode
{"_createdAt":{"$gte":{"$date":"2013-06-08T17:55:54.129Z"},"$lte":{"$date":"2013-07-10T17:55:54.129Z"}}}
/code/pre

if it works then please debug app and check that you use correct values in variables.

Your example worked. What i am figuring out is that the select list will not let me use a colon when storing a value in the component. Start Date and End Date are select list populated from a list service that is pulled from the appery db.

So my issue is that when i select the _createdAt date and display it in an alert it is not showing in iso format. How do i do that in Appery?

Set "Date Format"= "yy-mm-dd" on "Datepicker" element.
than get date value from "Datepicker" :
pre
code
var s = $('div[dsid="startDate"] input').val();
var s1=s+'T00:00:00.00Z';
/code
/pre

Thank you VERY much. That did it. I have posted the complete code for other users.
codevar s = $('div[dsid="startDate"] input').val();
var e = $('div[dsid="endDate"] input').val();
var s1= s+'T00:00:00.00Z';
var e1= e+'T00:00:00.00Z';
return '{"_createdAt":{"$gte":{"$date":"' + s1 + '"},"$lte":{"$date":"' + e1 + '"}}}'/code

Tommy, thank you for sharing!

Hello
I want to fetch particular records from collection using where clause.
I have create a database service with following settings

Name : user_category_list_service

URL : {database_url}/collections/user_category

Method : POST

Data Type : JSON

Settings : mySettings

Security Context : NONE

Content Type : JSON

Use Appery.io Proxy : not checked.

Request Parameters

X-Appery-Database-Id : {database_id} include in header
X-Appery-Session-Token : accesstoken include in header
Content-Type : application/json

Now I want records for particular user_id. How i pass where { "user_id" : "simple_user_id" }

Thanks

Hello! Add request parameter "where" (or you can create query service instead of list with "where" parameter added.

Do you mean under "user_id" _id field in builder?

If you use Test tab inside editor then add request in "where" field, for example code{"id": "520c76f6e4b04c2d0a0419bb"}/code
If you use in mapping then add JS which returns this line http://docs.appery.io/documentation/u...
For example:
codereturn '{"id": "' + value + '"}';/code

So I have now decided that I need to also filter on two collumns in the Database not one. I am using the following code that I have described above. Now I want to also limit the records to the user ID that is stored in local storage. The variable for the UserID is uid. codevar uid = Appery('unique').val();/code

How would I add two items in the where statement? I have tried many versions of this code but it doesnt work. codereturn '{"_createdAt":{"$gte":{"$date":"' + s1 + '"},"$lte":{"$date":"' + e1 + '"}},{"userID":"' + uid + '"}}'; /code

Hi Tommy,

Lets try this:

prereturn '{$and: [{"_createdAt": $and: [{"$gte": {"$date": "' + s1 + '"}},{"$lte": {"$date": "' + e1 + '"}} ]}, {"userID":"' + uid + '"} ]}';/pre