Forum | Appery.io

Hi,
I am having problems combining two where clauses:

I am trying to combine these clauses:
1.
var useridexpensevar = localStorage.getItem("useridexpense");
var whereObject = {"userprofid": {"$inQuery": {_id: useridexpensevar } //}};
return JSON.stringify(whereObject);

2.
var staridvar = localStorage.getItem("starid");
var whereObject = {"starid": {"$inQuery": {_id: staridvar } }};
return JSON.stringify(whereObject);

And this is what I have made:
var useridexpensevar = localStorage.getItem('useridexpense'), star = localStorage.getItem('starid');
var whereObject = {"userprofid": {"$inQuery": {id: useridexpensevar } } + {"starid": {"$inQuery": {id: star } } }};
return JSON.stringify(whereObject);

What is wrong with it? There are no JS issues int he console or any red flags when I put the code in.

Thanks

This is an example how I did it, not sure if this helps, I separated with a comma.

var whereClause = { "region": localStorage.getItem("myRegion"),
"menuItem": localStorage.getItem("mySubMenuItem")};
return JSON.stringify(whereClause);

Hello,

Please look at our documentation for queries like that: https://devcenter.appery.io/documenta...

Aren't I doing the same thing with the $and but with a '+' sign, if I use the $and it comes up with errors.

Hi Logan - Could you please show us your full where query string that you are using?

The one labeled 'And this is what I have made: ' is the full string we are using.

Sorry, I don't see anything - could you please repeat.

Alright, my bad:
var useridexpensevar = localStorage.getItem('useridexpense'), star = localStorage.getItem('starid');
var whereObject = {"userprofid": {"$inQuery": {id: useridexpensevar } } + {"starid": {"$inQuery": {id: star } } }};
return JSON.stringify(whereObject);

Thanks

Logan, please use:

prereturn '{"$and":[{"userprofid": {"$inQuery": {"id": "'+useridexpensevar+'" } }}, {"starid": {"$inQuery": {"id": "'+star+'"}}}]}';/pre
instead of:

prevar whereObject = {"userprofid": {"$inQuery": {id: useridexpensevar } } + {"starid": {"$inQuery": {id: star } } }};
return JSON.stringify(whereObject); /pre

Thanks so much! This was perfect