How to update array of an object in mongodb?

Question

Messages.update(
    {_id: docId, "messages.senderId": friendId},
    {
        $set: {"messages.$[elem].read": true}
    },
    {
        multi: true,
        arrayFilters: [{"elem.senderId": friendId}]
    },
    (err, result) => {
        if (err) {
            return res.status(500).json({message: "Something error occured" + err})
        } else {
            return res.status(200).json({message: "Successfully", result})
        }
    }
)

when this command execute I get an error.

Could not find path "messages.0.senderId" in schema" and my schema is

const Schema = new mongoose.Schema({
    conversations: Array,
    messages: Array
})

How can solve this problem?, please, help me.

i follow this solution but not work.

Tom Slabbaert · Accepted Answer · 2022-07-03 11:57:02Z

2

This is a moongoose error as your schema does not specify the complete structure. You can see here that the Mongo update syntax is working as expected.

It seems this is a missing feature for now, As seen in the source code (mongoose v6)

if (schematype == null) {
  if (!strictQuery) {
    return;
  }
  // For now, treat `strictQuery = true` and `strictQuery = 'throw'` as
  // equivalent for casting array filters. `strictQuery = true` doesn't
  // quite work in this context because we never want to silently strip out
  // array filters, even if the path isn't in the schema.
  throw new Error(`Could not find path "${filterPath}" in schema`);
}

The comment acknowledges this bad behaviour, but this is still the logic used even for "mixed type" arrays.

You can either:

Update your Array schema to fully describe the object:

const Schema = new mongoose.Schema({
    conversations: Array,
    messages: [{senderId: String}]
})

Pass the strict: false option in the update, this will also disable other validations which means it's the less preferable approach:

Messages.update(
    {_id: docId, "messages.senderId": friendId},
    {
        $set: {"messages.$[elem].read": true}
    },
    {
        multi: true,
        strict: false,
        arrayFilters: [{"elem.senderId": friendId}]
    },
    (err, result) => {
        if (err) {
            return res.status(500).json({message: "Something error occured" + err})
        } else {
            return res.status(200).json({message: "Successfully", result})
        }
    }
)

answered Jul 3, 2022 at 11:57

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

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

8 Comments

hydraCode Over a year ago

but, Brother it is give error during save messages in db after configuration Schema. My configuration for save messages in db.

const message = await Messages(                         { conversations: [req.body.adminId, req.body.friend_id],                             messages: {message: messageChange,time: req.body.time,senderId: req.body.adminId,                                type: req.body.type,                                 messageID: req.body.messageID,                                 read: req.body.seen                              }}) message.save()

Tom Slabbaert Over a year ago

did you add all the relevant fields to the schema? not just senderId

hydraCode Over a year ago

yes, ` new mongoose.Schema({ conversations: Array, messages: [{ message: String, senderId: String, type: String, messageID: String, read: Boolean, time:{ type: String, default: Date.now() } }], })`

hydraCode Over a year ago

and give this kind of error,, ValidationError: messages.0: Cast to [string] failed for value \"[\\n' +\n ' {\\n' +\n \" message: 'gek',\\n\" +\n ' time: 1656852475119,\\n' +\n \" senderId: '62bb59979690362946aedb02',\\n\" +\n \" type: 'text',\\n\" +\n ' messageID: 163172,\\n' +\n ' read: false\\n' +\n ' }\\n' +\n ']\" (type string) at path \"messages.0\"","messageId":163172}

hydraCode Over a year ago

help me brother 😥😥😥😥

|

Tom Slabbaert · Accepted Answer · 2022-07-03 12:02:17Z

This is a moongoose error as your schema does not specify the complete structure. You can see here that the Mongo update syntax is working as expected.

It seems this is a missing feature for now, As seen in the source code (mongoose v6)

if (schematype == null) {
  if (!strictQuery) {
    return;
  }
  // For now, treat `strictQuery = true` and `strictQuery = 'throw'` as
  // equivalent for casting array filters. `strictQuery = true` doesn't
  // quite work in this context because we never want to silently strip out
  // array filters, even if the path isn't in the schema.
  throw new Error(`Could not find path "${filterPath}" in schema`);
}

The comment acknowledges this bad behaviour, but this is still the logic used even for "mixed type" arrays.

You can either:

Update your Array schema to fully describe the object:

const Schema = new mongoose.Schema({
    conversations: Array,
    messages: [{senderId: String, read: Boolean}]
})

Pass the strict: false option in the update, this will also disable other validations which means it's the less preferable approach:

Messages.update(
    {_id: docId, "messages.senderId": friendId},
    {
        $set: {"messages.$[elem].read": true}
    },
    {
        multi: true,
        strict: false,
        arrayFilters: [{"elem.senderId": friendId}]
    },
    (err, result) => {
        if (err) {
            return res.status(500).json({message: "Something error occured" + err})
        } else {
            return res.status(200).json({message: "Successfully", result})
        }
    }
)

Collectives™ on Stack Overflow

How to update array of an object in mongodb?

2 Answers 2

8 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related