Mongodb: update array of array

Question

I have a collection named products in which I want to update the code which have the empty field under options.stores.code structure is as follow:-

{
"_id": ObjectId(),
"sku": "V4696-DR-V33",
"options": [
    {
        "sku": "8903689984338",
        "stores": [
            {
                "code": "AND1",
                "zipcode": "110070",
                "inventory": -5000
            },
            {
                "code": "AND2",
                "zipcode": "201010",
                "inventory": -5000
            },
            {
                "code": "AND3",
                "zipcode": "411001",
                "inventory": -5000
            },
            {
                "code": "AND4",
                "zipcode": " 700020",
                "inventory": -5000
            }
        ],
    },
    {
        "sku": "1742564789",
        "stores": [
            {
                "code": "AND1",
                "zipcode": "110070",
                "inventory": -5000
            },
            {
                "code": "AND2",
                "zipcode": "201010",
                "inventory": -5000
            },
            {
                "code": "AND3",
                "zipcode": "411001",
                "inventory": -5000
            },
            {
                "code": "AND8",
                "zipcode": " 700020",
                "inventory": -5000
            }
        ],
    },

]

}

Want to update the inventory, which have the same code.

Thanks for the reply. I have checked the query is working only for the single object inside the array.but not for the all the matched element. — Neo
– Neo, Commented Sep 24, 2015 at 10:24

Abie · Accepted Answer · 2015-09-07 09:42:58Z

0

For updating empty store codes:

db.products.update({"code":""},{$set:{"code":"new value"}}

answered Sep 7, 2015 at 9:42

Abie

7445 silver badges13 bronze badges

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

1 Comment

Neo Over a year ago

This is normal update, but it will not the way I am expecting.

Ashesh Khatri · Accepted Answer · 2015-09-24 10:32:18Z

0

using the python script use any loop for this update........... and made a slight modification------{$set:{"options.(loop variable).stores.$.inventory":}} this can help for query

answered Sep 24, 2015 at 10:32

Ashesh Khatri

1622 silver badges12 bronze badges

3 Comments

Neo Over a year ago

can we do with mongo query without using any loop, as I have many records to update.

Ashesh Khatri Over a year ago

there is no direct way to update using mongo query, u have to use any loop.

Neo Over a year ago

k thanks will work on this solution and post you the update : ) Thanks

Collectives™ on Stack Overflow

Mongodb: update array of array

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related