Page 3 of 4

Multiple values for "where" in one database query

Posted: Mon Feb 18, 2013 6:33 am
by Kateryna Grynko

Hi,

To search several field values you can use the following syntax:code{"Maker" : {$in: ["Samsung", "Nokia", "Sony"]} }/code
To search in several fields you should use commas:code{"Maker" : {$in: ["Samsung", "Nokia", "Sony"]}, Model: "Galaxy SIII" }/code


Multiple values for "where" in one database query

Posted: Mon Feb 18, 2013 8:18 am
by Kateryna Grynko

Hello,
We have non-relational database therefore this request is impossible yet.


Multiple values for "where" in one database query

Posted: Wed Feb 20, 2013 4:06 am
by Ryan Rigby

Wow could you answer be anymore useless??

How about a couple suggestions then on how to architect the data in the database


Multiple values for "where" in one database query

Posted: Wed Feb 20, 2013 4:24 am
by maxkatz

Let's try and stay constructive in this forum.

We use MongoDB in the backend, thus a tradition SQL query will not always work. Here is more information on how to do a query with a pointer: http://docs.tiggzi.com/documentation/...


Multiple values for "where" in one database query

Posted: Fri Jan 31, 2014 5:47 pm
by Ignacio Valdés

I try to do it but does not work for me :(

http://cl.ly/image/3f00140f1e2F


Multiple values for "where" in one database query

Posted: Sat May 16, 2015 5:00 am
by EJLD

Hi There,

in a DB field named "countryName", I am looking for the country "Zambia" but I don't want to key all of the Zambia word.

I thought it would work with {"countryName":{"$in":["Zam"]}}
but nothing comes out.

I must have mis understood the operator '$in' .
may I ask you for the proper operator is any ?

many thks in advance,

Eric


Multiple values for "where" in one database query

Posted: Sat May 16, 2015 5:17 am
by EJLD

Hi There (again) :-)
forget my question above ... I found the proper operator.
for those who could be interested

{"countryName": { $regex: "Zam" } }

more to find out on

http://docs.mongodb.org/manual/refere...

enjoy your wknd !

Eric


Multiple values for "where" in one database query

Posted: Sat May 16, 2015 5:20 am
by Evgene Karachevtsev

Hello Eric,

Thank you for the update!


Multiple values for "where" in one database query

Posted: Mon Jul 20, 2020 7:48 pm
by Joseph Yeung

\""Nokia\""]}} ' "" ; .. data: encodeURI(JSON.stringify(whereClause))


Multiple values for "where" in one database query

Posted: Mon Jul 20, 2020 7:48 pm
by Joseph Yeung

\""Nokia\""]}} ' "" ; "