Mongo DB: Append a value to a nested array

Question

I think there might be better ways to store data but the app I am working on has some data stored like this.

I have a document with nested arrays. In this particular example, would it be possible to append a new element "value3" to an array inside products whose "productId" matches the condition. So, basically look for productId and append "value3" to the array which has matching "productId".

I am just learning about MongoDB so if you can provide some suggestions for changing schema, even that would be very helpful.

P.S. Not sure if it helps but I am using node.js

{"_id":
    {"$oid":"601baf0e5c307422c0fa958c"},
    "sale":"Test Sale",
    "products":[
      [
        ["productId","value1","value2"],
        ["productId","value1","value2"]
      ],
      [
        ["productId","value1","value2"],
        ["productId","value1","value2"]
      ],
      [
        ["productId","value1","value2"],
        ["productId","value1","value2"]
      ]
    ],
    "collectionProducts":["id","id","id"]
}

Could you please provide an example simulating data. It's not necessary real data. — Oscar López
– Oscar López, Commented Feb 4, 2021 at 18:58

R2D2 · Accepted Answer · 2021-02-04 19:55:22Z

1

Maybe something like this:

 db.store.update({},{$push:{"products.$[].$[k]":"value3"}},{ arrayFilters: [{ k:'productId' }]})

answered Feb 4, 2021 at 19:55

R2D2

10.9k2 gold badges20 silver badges41 bronze badges

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

2 Comments

Ashish Over a year ago

Thanks, it worked. I have one more question though. Now, I wanted to find array containing matching "productId" in the same document as matching "sale". I didn't find much in the mongo documentation regarding this.

Ashish Over a year ago

link to the other question

Collectives™ on Stack Overflow

Mongo DB: Append a value to a nested array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related