How can I access values in a nested mongodb object?

Question

I have a Company mongodb structure like this:

{ "companyName" : "SomeCompany",


"Products" : [
        {
            "productId" : "e3rQACssGkfp9zsue",
            "productCode" : "271102502",
            "memberPrice" : "200",
        },
        {
            "productId" : "e3rQACssGkfp9zsue",
            "productCode" : "271102502",
            "memberPrice" : "500",
        },
    ]
}

Each Company has a nested object called Products, which has its own attributes. How can I loop through the object to print out just the memberPrice from Products? I am trying to do something like:

console.log(Company.Products.memberPrice)

which returns undefined...

chridam · Accepted Answer · 2015-05-13 15:22:50Z

3

Use the array's forEach() method to iterate over the element's property:

var obj = { 
    "companyName" : "SomeCompany",
    "Products" : [
        {
            "productId" : "e3rQACssGkfp9zsue",
            "productCode" : "271102502",
            "memberPrice" : "200",
        },
        {
            "productId" : "e3rQACssGkfp9zsue",
            "productCode" : "271102502",
            "memberPrice" : "500",
        },
    ]
};

obj.Products.forEach(function(product){
    console.log(product.memberPrice); // 200, 500
})

-- UPDATE --

You could consider the following (thanks to @Michael) if you want to iterate the object in mongo shell, using the find() cursor's forEach() method:

db.collection.find().forEach(function(doc){
    doc.Products.forEach(function(p){ 
        print(p.memberPrice);
    });
});

edited May 13, 2015 at 15:22

answered May 13, 2015 at 15:08

chridam

104k26 gold badges246 silver badges243 bronze badges

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

3 Comments

chridam Over a year ago

@Michael Fastest gun in the west :P

Sede Over a year ago

One more thing since OP tags question mongodb. why not something like db.collection.find().forEach(function(doc){doc.Products.forEach(function(p){ print(p.memberPrice)})})

chridam Over a year ago

@Michael That's another possible solution as well, kudos for mentioning!

Collectives™ on Stack Overflow

How can I access values in a nested mongodb object?

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