update Object inside array of Object with mongoose

Question

I'm trying to update and object inside array in MongoDB. my model is:

let userSchema = new mongoose.Schema({
  userName: {
    type: String
  },
  password: {
    type: String
  },
  history: []

});

And inside history each element is from the next type: id, array(named ing_array) and boolean field called favorite.

I'm trying to update the favorite field with mongoose with the userName and the id.

I tried to do this query and I didn't succed.
Could some one tell me whats worng? [object photo]: https://i.sstatic.net/2mYpP.png

User.findOneAndUpdate(
  { "userName": user_name, "history.id": id },
  { "$set": { "history.$.favorite": true }}
);

J.F. · Accepted Answer · 2021-08-17 12:58:27Z

3

You have to use arrayFilters in this way:

db.collection.update({
  "userName": "uname",
  "history.id": 1
},
{
  "$set": {
    "history.$[element].favorite": false
  }
},
{
  "arrayFilters": [
    {
      "element.id": 1
    }
  ]
})

Note that update query has the format: update(query, update, options) (Check the docs).

When you do { "userName": user_name, "history.id": id } you are telling mongo "Give me all documents where userName is user_name and array history has an id with value id. This return all history array because it belows to the document.

To update an specific object into the array is neccessary to use arrayFilters to tell mongo which object do you want to update. In this case the object where id is equal to 1. You can use as you want to match wit your requirements.

Example here

answered Aug 17, 2021 at 12:58

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

6 Comments

Naor Pashay Over a year ago

first of all thank you, i need to put the name of the mongoose model instead the db.collection right? if i med let User= mongoose.mode('User,...) so i need to do User.update?

J.F. Over a year ago

Yes! You have to use your mongoose model User.updateOne(/*the query*/).

Naor Pashay Over a year ago

its not working for me..i see that in the example its working.. do you can suggest what is the problem?

J.F. Over a year ago

What's the problem? Is not updating the field? Check if first object (query object) is finding some document using yourModel.find({ "userName": user_name, "history.id": id }). If this works the query should works. Also note that where I've used "element.id": 1 you have to use "element.id": id

Naor Pashay Over a year ago

i think that the problem is in the history array. i dont think that i can do history.id becuse history is an array so i think this is the problem.. do you have any clue?

|

Collectives™ on Stack Overflow

update Object inside array of Object with mongoose

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related