Hi,
I am trying to write a Server code to talk to multiple collections in a database for achieving my logic. Off late, it has started behaving very erratic. Looks like a bug in appery when it tries to handle values from multiple collections.
I do the first search as follows:
var params_userinv = {}; //Define parameters object
params_userinv.criteria = { //Query criteria:
"Userid":username
};
query = Collection.query(DB_id,collectionName,params_userinv.criteria);
Post which I try to manipulate some values in other collection in the same database as follows, it gives an error. All columns have been verified and found to be present. Can someone tell me what is the issue?
for (var i=0;i:query.Scrip_Name};
query_Tech_Data = Collection.query(DB_id,collectionName_Tech_Data,params);
sum_curr_val = sum_curr_val + (query.Scrip_Qty * query_Tech_Data[0].Close);
}}