MongoDB: how to update a nested array [duplicate]

Question

I have collection with data:

{
  "_id": { "$oid":"5c3334a8871695568817ea26" },
  "country":"Afghanistan",
  "code":"af",
  "region":[
    {
      "path":["Afghanistan"],
      "_id":{"$oid":"5c3366bd3d92ac6e531dfb43"},
      "name":"Badakhshan",
      "city":[]
    },
    ...
  ]
},

And I need to add cities (Array) inside city field. My model looks like this:

const schema = new mongoose.Schema({
  country: { type: String },
  code: { type: String },
  region: [{
    name: { type: String },
    path: { type: Array },
    city: [{
      name: { type: String },
      path: { type: Array },
      latitude: { type: String },
      longitude: { type: String },
    }],
  }],
})

I send query

Model.updateOne(
  { code: country.code },
  { $push: { 'region.city': { $each: savedCities } } },
)
.exec()

and receive the error MongoError: Cannot create field 'city' in element {region: [..... What is my mistake? I look similar topics but not found the answer.

Do you want to add that cities to every region or to this particular one (Badakhshan) ? — mickl
– mickl, Commented Jan 14, 2019 at 8:38

mickl · Accepted Answer · 2019-01-14 08:44:19Z

2

You can use the $ positional operator to indicate which element od region array should be updated, try:

Model.updateOne(
    { code: country.code, 'region.name': 'Badakhshan' },
    { $push: { 'region.$.city': { $each: savedCities } } },
)

answered Jan 14, 2019 at 8:44

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

MongoDB: how to update a nested array [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related