mongodb query with array

Question

I have this collection:

{"_id"=>BSON::ObjectId('5728cd81c08460ead'), "age"=>4, "name"=>"Diogo"}
{"_id"=>BSON::ObjectId('5728cd81c08460ead'), "age"=>22, "name"=>"Tiago"}
{"_id"=>BSON::ObjectId('5728cd81c08460ead'), "age"=>15, "name"=>"Marie"}
{"_id"=>BSON::ObjectId('5728cd81c08460ead'), "age"=>2, "name"=>"JJ"}
{"_id"=>BSON::ObjectId('5728cd81c08460ead'), "age"=>44, "name"=>"John"}

and this array of names:

names_array = ["John", "Marie", "Tiago"]

How can I use names_array to search for names in mongodb collection?

I want this output:

{"_id"=>BSON::ObjectId('5728cd81c08460ead'), "age"=>4, "name"=>"Diogo"}
{"_id"=>BSON::ObjectId('5728cd81c08460ead'), "age"=>22, "name"=>"Tiago"}
{"_id"=>BSON::ObjectId('5728cd81c08460ead'), "age"=>15, "name"=>"Marie"}

this query not work :

coll.find( { name: names_array } )

Ilya · Accepted Answer · 2016-05-04 11:25:33Z

2

coll.find('name' => { '$in' => names_array } } )

edited May 4, 2016 at 11:25

answered May 4, 2016 at 11:17

Ilya

13.5k5 gold badges41 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

lolix Over a year ago

I can't. undefined method `where' for #<Mongo::Collection:0x007fb2f912a738>

Roman Kiselenko Over a year ago

where method available in the mongo ORM.

Collectives™ on Stack Overflow

mongodb query with array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related