MongoDB: find element by array element

Question

I am having the following issue. Generally I have a collection holding objects with the following structure:

{
    _id: ObjectId("4f941bb2e4b06c6af7f80a0d"),
    fooId: ObjectId("4f941bb2e4b06c6af7e50aff"), 
    barsIds: [ObjectId("4f941bb2f5606c6af7f80ff5"), ObjectId("4f941bbc3fb06c6af7f80ccf")]
}

What is the query to find all elements in the collection that contain a given id in the barsIds property ?

Is it something like:

db.collectionName.find({"barsIds" : [ { "$oid" : "5300c6ba4a5ce5614bcd5d9a"}]})

Shnkc · Accepted Answer · 2014-02-16 14:45:23Z

1

This is exactly what you are looking for:

db.collectionName.find({"barsIds" : ObjectId("4f941bb2f5606c6af7f80ff5") })

This query looks for documents whose barsIds elements are given object id. Or if barsIds is an array, this query looks for docs whose barsIds elements contain given object id.

edited Feb 16, 2014 at 14:45

answered Feb 16, 2014 at 14:40

Shnkc

2,1881 gold badge28 silver badges35 bronze badges

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

Comments

Rafa Paez · Accepted Answer · 2014-02-16 14:41:09Z

0

Try with something like this

db.collectionName.find({:barsIds => {"$in" => BSON::ObjectId("5300c6ba4a5ce5614bcd5d9a")}})

answered Feb 16, 2014 at 14:41

Rafa Paez

4,87023 silver badges35 bronze badges

Collectives™ on Stack Overflow

MongoDB: find element by array element

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related