i have a problem with invoking a query using pointer as the criteria.
I have a collection "Merchandise", which has a column "Category", which is of pointer type referring to another collection "Category". The collection "Category" has two columns, "_id" and "Category Name".
When i give a normal type into a query as criteria it works -
params.criteria={"Value":200};
var categoryList = Collection.query(DB_Id, "Merchandise",params);
console.log(categoryList.length); //== gives 2 as answer
But when i give a pointer type criteria, it fails
params.criteria={"Category":{"_id":"5400c608e4b051d053e3d986","CategoryName":"Movie Tickets"}};
params.include="Category";
var categoryList = Collection.query(DB_Id, "Merchandise",params);
console.log(categoryList.length); //==gives 0 as answer
Any suggestion?