javascript or query using $or

Mon May 18, 2015 1:53 pm

I have a database in my column called route its a number column

I need to have the where query search for numbers that is 1 or 3 only.

Can you please help me I have tried all of these

//return '{"route":"'+value+'"}';

//return '{"$or":"{"route": "3"},{"username": "a href="mailto:vinny2010b@gmail.com" rel="nofollow"vinny2010b@gmail.com/a"}}';

//return {"route": {"$in": [1,3]}};

//a = {"route": {"$in": [1,3]}};
//return a;

Mon May 18, 2015 4:37 pm

Hello Vinny,

Tue May 19, 2015 1:57 pm

Thanks but it does not show how to implement using javascript. Can you please explain in more detail.

I have a colum in my database with number 1,2,3,4

I need query it and the results to show rows that have a

1 and 4
or
2 and 4
or
3 and 4.

Thank you

Tue May 19, 2015 4:24 pm

I thought this was it

return {"route": {"$in": [1,3]}};

Tue May 19, 2015 5:27 pm

never mind I was query a number column and just changed it to a string.

Thanks