Adding a new object to an existing array of data document?

Question

I am new at MongoDB and I want to append an "address 2" to the "location" array of my "CUSTOMER" document that has first name of "Jimmy".

The collection is like this:

db.collection.insert(
  {
    "CUSTOMER": {
      "first name": "Jimmy",
      "location": [{"address": {"num": 1}}]
    }
  }
);

I tried the following, but it created a new set insted putting a new address inside the array of location:

db.collection.update({"CUSTOMER.first name": "Jimmy"}, {$set:{"location":{"address": "num":2 }}});

I tried to put the "location" prior to the $set put it doesn't work.

I need the right prototype of doing such thing.

The expected outcome is the following:

db.collection.insert(
  {
    "CUSTOMER": {
      "first name": "Jimmy",
      "location": [{{"address": "num": 1}},
                   {"address": "num": 2}}
]
    }
  }
);

To sum up, I want to put a new address to the array of location above.

{ "CUSTOMER": { "first name": "Jimmy", "location": [{{"address": {"num": 1}}, {"address": {"num": 2}] } } — Aki
– Aki, Commented Jun 4, 2020 at 6:16

Anurag Wagh · Accepted Answer · 2020-06-04 06:22:37Z

1

$set won't help here you'll have to use $push operator

db.customers.update({"CUSTOMER.first name" : "Jimmy"}, {$push: {"CUSTOMER.location": {"address" : {"num" : 1}}}})

answered Jun 4, 2020 at 6:22

Anurag Wagh

1,0866 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Adding a new object to an existing array of data document?

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