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.

you may find answer here [link](http://stackoverflow.com/questions/32733790/want-to-update-array-of-array-object-value-in-mongo) — Ashesh Khatri, Sep 24 '15 at 10:21
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, Sep 24 '15 at 10:24

score 0 · Answer 1 · answered Sep 07 '15 at 09:42

0

For updating empty store codes:

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

answered Sep 07 '15 at 09:42

Abie

624
5
12

This is normal update, but it will not the way I am expecting. – Neo Sep 24 '15 at 06:03

score 0 · Answer 2 · answered Sep 24 '15 at 10:32

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 '15 at 10:32

Ashesh Khatri

162
2
11

can we do with mongo query without using any loop, as I have many records to update. – Neo Sep 24 '15 at 10:34
there is no direct way to update using mongo query, u have to use any loop. – Ashesh Khatri Sep 24 '15 at 10:36
k thanks will work on this solution and post you the update : ) Thanks – Neo Sep 24 '15 at 10:38

Mongodb: update array of array

2 Answers2