MongoDB update a document field in Array of Arrays

Question

How to update ($set) a field "text" that matching "callback_data":"like" in document like this:

"data": {
    "buttons": [
        [{
            "text": "Button",
            "url": "https://example.org"
        }],
        [{
            "text": "👍",
            "callback_data": "like"
        }, {
            "text": "👎",
            "callback_data": "dislike"
        }]
    ]
}

Tushar Gupta - curioustushar · Accepted Answer · 2021-04-27 00:32:10Z

1

Demo - https://mongoplayground.net/p/_g9YmDY5WMn

Use - update-documents-with-aggregation-pipeline

$map $mergeObjects $cond

db.collection.update({},
[
  {
    $set: {
      "data.buttons": {
        $map: {
          input: "$data.buttons",
          in: {
            $map: {
              input: "$$this", // array inside buttons 
              in: {
                $cond: [
                  { $eq: [ "$$this.callback_data", "like" ] }, // condition
                  { $mergeObjects: [ "$$this", { text: "changed" } ] }, // true
                  "$$this" // false
                ]
              }
            }
          }
        }
      }
    }
  }
],
{
  multi: true
})

answered Apr 27, 2021 at 0:32

Tushar Gupta - curioustushar

57.2k24 gold badges106 silver badges110 bronze badges

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

Collectives™ on Stack Overflow

MongoDB update a document field in Array of Arrays

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related