Forum | Appery.io

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;

Hello Vinny,

Please follow documentation below: https://devcenter.appery.io/documenta...

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

I thought this was it

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

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

Thanks