Hello Friends!
We are getting a weird error after trying to add this code, and are wondering what we are doing wrong:
var staridvar = localStorage.getItem("userprofileid");
var whereObject = {"userprofileid": {"$inQuery": {_id: staridvar } }};
return JSON.stringify(whereObject);
Error:
code: "DBSQ272"
description: "Mongo error: 'Can't canonicalize query: BadValue unknown operator: $inQuery'"
Keep rocking,
DN
Hello Devin,
Please use Quotation marks in the request parameters as it is shown here: https://devcenter.appery.io/documenta...
Hello there Sergiy,
Do you have any idea about why this code works:
var staridvar = localStorage.getItem("starid");
var whereObject = {"staridid": {"$inQuery": {_id: staridvar } }};
return JSON.stringify(whereObject);
And this one returns with the DB error:
var userprofvar = localStorage.getItem("userprofileid");
var whereObject = {"userprofileid": {"$inQuery": {_id: userprofvar } }};
return JSON.stringify(whereObject);
They seem the exact same to me, other than the local storage variable they are both trying to get.
Hello Devin,
Please use prevar whereObject = {"staridid": {"$inQuery": {"id": staridvar } }}; /pre instead of: prevar whereObject = {"staridid": {"$inQuery": {id: staridvar } }}; /pre
See example here: https://devcenter.appery.io/documenta...
For whatever reason, the code is still returning the same response:
"Mongo error: 'Can't canonicalize query: BadValue unknown operator: $inQuery'"
Name
Here is the code:
var userprofvar = localStorage.getItem("userprofileid");
var whereObject = {"userprofileid": {"$inQuery": {"_id": userprofvar } }};
return JSON.stringify(whereObject);
Is there anything else clearly wrong?
Please provide us with a public app link (https://devcenter.appery.io/documenta...) and exact steps to reproduce this problem.
Ok:
http://appery.io/app/mobile-frame?src...
Just press 'login', and the userprofile screen will show up, and I gave the test user a profile
Thank you!
DN
Please clarify, what type does column "userprofileid" have?
It is a pointer. Do you think the error could be due to a listing service problem? I do not know where to put the $ in the success part of the list service.
It should work fine. Please share (http://devcenter.appery.io/documentat...) your app with a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a and provide us with the following information:
1) App name
2) Test credentials if login functionality is implemented in your app
3) Detailed steps to reproduce the issue