Return value from database using OR

[Tim Childs]

Hi,

I have a query service setup to an apery database and I am returning a value using:

return '{ $and: [ { "weight": "'+value+'" }, { "rank": "C" } ] }';

This works, but I also want to include a second OR argument for weight

i.e. return where weight = +value+ OR weight = localVar

I just do not know the correct syntax. Something like:

return '{ $and: [ { "weight": "'+value+'" OR localStorage.getItem("localVarName") }, { "rank": "C" } ] }';

Does anyone know the correct syntax?

Cheers,
Tim

[maxkatz]

You need to define 'where' query that looks like this:

code
where={"$or":[{"weight":{"$gt":10}},{"weight":{"$lt":100}}]}
/code

[Tim Childs]

I don't understand how that would work with my current code:

return '{ $and: [ { "weight": "'+value+'" }, { "rank": "C" } ] }';

I'm passing in +value+ but the second value will be a local variable.

[maxkatz]

Didn't you want to use OR (in subject)?

[Tim Childs]

OR on the weight

i.e. return name WHERE ( (weight = heavy OR light) AND rank = C)

[Kateryna Grynko]

Hi Tim,

Please use the following code:
precode{
$and: [{
rank: "value... C"
}, {
$or: [{
weight: "heavy..."
}, {
weight: "light..."
}]
}]
}/code/prePlace this code in one line.

[Tim Childs]

Hi Katya,

I tried the following but it just makes my app hang - maybe the syntax is incorrect?

return '{ $and: [{ rank: "C" }, { $or: [ { weight: "'+value+'" }, { weight: "'localStorage.getItem("weight2")'" }] }] }';

The following works OK:

return '{ $and: [ { "weight": "'+value+'" }, { "rank": "C" } ] }';

Many Thanks,
Tim

[Oleg Danchenkov]

Try this
return '{ $and: [{ "rank": "C" }, { $or: [ { "weight": "'+value+'" }, { "weight": "' + localStorage.getItem("weight2") + '" }] }] }';

[Tim Childs]

Perfect. Thank you!