CODEWITHSUNDEEP
arraysnode.jsmongodbmongoose
user2521439
user2521439

Reputation: 1425

Find a Mongodb document if it contains an element in the array in mongoose

If I have a field in a mongodb document which has an array, for example: 

"tags" : [  "tag", "etc1",  "etc2",  "etc3" ]

Is there a way that I can select that document if it contains the element 'etc1'?
If I try using the query:

db.coll.find({"tags" : { $elemMatch: { value0: 'etc1'} }})

but I need to know the position of the element in the array, which I don't know.
I have also tried:

db.coll.find({"tags" : { $elemMatch: 'etc1' }})

but it needs to be an object. Is there any way of doing this?

NB I am using mongoose but I wasn't sure how to construct the query

Upvotes: 3

Views: 12890

Answers (2)

Saheed Hussain
Saheed Hussain

Reputation: 1158

Apart from using $in operator you can also use $all operator like:

db.col1.find({"tags":{$all :["etc1"]}})

Upvotes: 3

Matthew Bakaitis
Matthew Bakaitis

Reputation: 11980

Use the $in operator as described in this question or this other question and as described in the mongodb docs and can be accessed in mongoose.

With it, you'll have a query that looks something like this...remembering that you must pass an array when using $in:

db.coll.find({"tags" : { $in : ['etc1'] } } );

Upvotes: 6

Related Questions