Writing a server code service where I'm trying to query a collection on a column using a request parameter 'grocerymasterid'. Here's the code and it returns all records if I remove the params but gives me an empty string if I add it in
var gmid = request.get("grocerymasterid") ;
var userName = request.get("userName"); //Store the user name
var userPass = request.get("userPass"); //and its password
var dbId = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx; // commented out
var collectionName = "Grocery" ;
var query = [] ;
try
{
result = {};
Code: Select all
var token = DatabaseUser.login(dbId, userName, userPass).sessionToken;
var params = {};
Code: Select all
params.criteria =
{
'grocerymasterid' : gmid
};
query = Collection.query(dbId,collectionName,params,token) ;
Code: Select all
response.success(query);
}
catch (e)
{
response.success("message: " + e.message + "ncode: " + e.code);
}