MongoDB: Variable nested in several objects

Question

I have a problem creating a query in MongoDB. I have the following JSON. How to ask mongodb question to get _id from level5 object?

{
  "Id": "1",
  "level1": {
    "level2": {
      "level3": {
        "level4": {
          "level5": {
            "_id": 2
          }
        }
      }
    }
  }
}

mickl · Accepted Answer · 2021-09-22 08:23:07Z

1

You can use the dot notation to get value from nested object:

db.collection.aggregate([
    {
        $project: {
            value: "$level1.level2.level3.level4.level5._id"
        }
    }
])

Mongo Playground

answered Sep 22, 2021 at 8:23

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

2 Comments

Paweł Ada Over a year ago

Need by aggregations not by find?

mickl Over a year ago

Just showing the way you can access it, same dot notation can be used for filtering etc. Nothing prevents you from fetching entire document and accessing that property in your code, what is your use-case?

Collectives™ on Stack Overflow

MongoDB: Variable nested in several objects

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related