Querying subdocument inside a subdocument of a collection in Mongodb

Question

I have the collection named companies as below.

I want to query the url corresponding to C1S1category1 . I do not know which companyName it belongs and which catergories it belongs to.

Please can you let me know what query I need to use in Mongoshell to query the document having catergoryname as C1S1category1

{"companyName": "C1",
"url": "www.com1",
"categories" : [
        {"SlNo" : 1,
        "url" : "www.com1",
        "subcategories" : [
            {
            "CatergoryName":"C1S1category1",
            "Url" : "www.com3"
            },
            {
            "CatergoryName":"C1S1category2",
            "Url" : "www.com3"
            }
            ]
         },
       {
       "SlNo" : 2,
        "url" : "www.com1",
        "subcategories" : [
            {
            "CatergoryName":"C1S2category1",
            "Url" : "www.com3"
            },
            {
            "CatergoryName":"C1S2category2",
            "Url" : "www.com3"
            }
            ]
        }   
    ]
},
{"companyName": "C2",
"url": "www.com21",
"categories" : [
        {"SlNo" : 1,
        "url" : "www.com22",
        "subcategories" : [
            {
            "CatergoryName":"C2S1category1",
            "Url" : "www.com23"
            },
            {
            "CatergoryName":"C2S1category2",
            "Url" : "www.com23"
            }
            ]
         },
       {
       "SlNo" : 2,
        "url" : "www.com1",
        "subcategories" : [
            {
            "CatergoryName":"C2S2category1",
            "Url" : "www.com23"
            },
            {
            "CatergoryName":"C2S2category2",
            "Url" : "www.com23"
            }
            ]
        }   
    ]
}

Vishwas · Accepted Answer · 2015-06-24 16:14:06Z

1

You need to use $elemMatch to get required output as following:

db.collection.find({
    "categories": {
    $elemMatch: {
        subcategories: {
            $elemMatch: {
                CatergoryName: "C1S1category1"
            }
        }
    }
    }
},{"categories.$":1,"companyName":1,"url":1}).pretty()

edited Jun 24, 2015 at 16:14

answered Jun 24, 2015 at 13:18

Vishwas

7,0777 gold badges46 silver badges70 bronze badges

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

3 Comments

Shambu Over a year ago

Thanks Vishwas. The above query returns complete document. Is it possible to return the sub documents that only get matched.

Neo-coder Over a year ago

@Sham332 use $ project like this find({your query criteria},{"categories.$":1}

Vishwas Over a year ago

@Sham332 please see edited answer. If you want only sub document then use {"categories.$":1} only.

Collectives™ on Stack Overflow

Querying subdocument inside a subdocument of a collection in Mongodb

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related