how to query a mongodb using a field which is inside an array of objects

Question

I have a db object like this:

{
   "_id": ObjectID("55c247f94b0c25e5d90d0f39"),
   "districts": [
    {
        "district": "Bangalore Urban",
        "stateID": 2,
        "districtID": 1
    },
    {
        "district": "Tumkur",
        "stateID": 2,
        "districtID": 2
    }
]
}

and i have stateID with me, what mongoose query should i write to get all objects from the array districts having the stateID 2

Please help!

possible duplicate of [Retrieve only the queried element in an object array in MongoDB collection](http://stackoverflow.com/questions/3985214/retrieve-only-the-queried-element-in-an-object-array-in-mongodb-collection). Various answers mentioning `.aggregate()` which is suitable for multiple matches. — Blakes Seven, Aug 06 '15 at 09:13

Thomas Bormans · Accepted Answer · 2015-08-06T12:33:06.027

3

You will need an aggregate query. Your Mongo query will look like this:

db.collection.aggregate([{
    $unwind: 'districts'
}, {
    $match: {
        'stateID': 2
    }
}, {
    $group: {
        _id: null,
        'districts': {
        $push: '$districts'
        }
    }
}]);

$unwind creates a record from each item inside an array.

$match is your query for finding items of your stateID

$group groups all your results in a custom key districts.

edited Aug 06 '15 at 12:33

answered Aug 06 '15 at 10:52

Thomas Bormans

5,156
6
34
51

this is returning me the full db object, no selection is happening – Syed Faizan Aug 06 '15 at 12:01
Oh, I see. I misunderstood your question. I have edited my answer. – Thomas Bormans Aug 06 '15 at 12:33
@syedfaizan Is this what you're looking for? – Thomas Bormans Aug 07 '15 at 07:23
1

Thanks bro , you saved my day, forgot to comment yesterday, sorry – Syed Faizan Aug 07 '15 at 13:57

how to query a mongodb using a field which is inside an array of objects

1 Answers1