Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 934
user2521439 Avatar asked Feb 02 '26 20:02

user2521439


2 Answers

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'] } } );

like image 142
Matthew Bakaitis Avatar answered Feb 05 '26 11:02

Matthew Bakaitis


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

db.col1.find({"tags":{$all :["etc1"]}})
like image 22
Shahid Hussain Avatar answered Feb 05 '26 13:02

Shahid Hussain



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!