Query deeply embeded documents in MongoDB with C# driver

Question

This is just an example code... I have managed to get to the third embeded document using .$ , but not further... How do I query the fourth nested part(article headings)?

  {
    "bookTitle": "MongoDB",
    "_id": ObjectId("530dea1d2dbf280000533b60"),
    "bookChapters": [{
    "chapterTitle": "chapterTitle",
    "_id": ObjectId("530dea1d2dbf280000533b61"),
    "chapterArticles": [{
        "articleTitle": "articleTitle",
        "_id": ObjectId("530dea1d2dbf280000533b62"),
        "articleHeadings": [{
            "headingTitle": "headingTitle",
            "_id": ObjectId("530dea1d2dbf280000533b63")
        }]
    }]
    }],
    "__v": 0
}

Community · Accepted Answer · 2017-05-23 12:05:58Z

1

You can use $elemMatch to match nested element in array. I used headingTitle to match here. Query will be like following-

db.collection.find({
    "bookChapters": {
    "$elemMatch": {
        "chapterArticles": {
            "$elemMatch": {
                "articleHeadings": {
                    "$elemMatch": {
                        "headingTitle": "headingTitle"
                    }
                }
            }
        }
    }
    }
})

If you want to convert it to mongo c# driver then you can refer this

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Jun 10, 2015 at 7:51

Vishwas

7,0777 gold badges46 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

Query deeply embeded documents in MongoDB with C# driver

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related