Update element in array in mongo db

Question

I have a document structured like this:

{
        "shedule": [
          {
            "SUN": {
              "status": false,
              "task": []
            }
          },
          {
            "MON": {
              "status": false,
              "task": []
            }
          },
        ]
      }

How to update status to false and push new element to task array in sun object.

Here is the expected output.

{
        "shedule": [
          {
            "SUN": {
              "status": true,
              "task": [1,2]
            }
          },
          {
            "MON": {
              "status": false,
              "task": []
            }
          },
        ]
      }

YuTing · Accepted Answer · 2021-08-26 05:46:18Z

1

If your SUM always at the first place, this is the answer:

db.collection.update(
    {},
    { 
        $push: { 
            "shedule.0.SUN.task": { 
                $each: [ NumberInt(1), NumberInt(2) ] } },
        $set: { "shedule.0.SUN.status": true } 
    }
)

answered Aug 26, 2021 at 5:46

YuTing

6,6692 gold badges8 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Update element in array in mongo db

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