Mongoose - Update an object inside nested array

Question

My Mongo schema looks like this, I want to update a flashcard object located in an array of flashcard also located in an array of subject.

const classrooms = new mongoose.Schema({
    name: String,
    year: String,
    student: [
        {
            firstname: String,
            lastname: String,
            mail: String,
            userId: String,
        }
    ],
    subject: [
        {
            subjectId: String,
            flashcard: [
                {
                    title: String,
                    tag: []
                }
            ]
        }
    ]
});

What I am doing is

const flashcard = await classroomModel.findOneAndUpdate({
    _id : classroomId,
    "subject" : {
        "subjectId" : subjectId,
        "subject.flashcard" : {
            "_id" : flashcardId
        }
    },
    "$set" : {
        "flashcard.title" : "new title"
    }
})

But this is deleting all flashcards located inside an object. Any help would be appreciated.

subject.flashcard does not have an _id field. It's an array of objects. — Yoav Kadosh
– Yoav Kadosh, Commented Nov 4, 2021 at 9:46

Yong Shun · Accepted Answer · 2021-11-04 09:49:52Z

1

You need arrayFilters to specify the (to-be-updated) flashcard document that meets the criteria for subject and flashcard.

db.collection.update({
  _id: 1//classroomId,
  
},
{
  "$set": {
    "subject.$[subject].flashcard.$[flashcard].title": "new title"
  }
},
{
  arrayFilters: [
    {
      "subject.subjectId": 1//subjectId
      
    },
    {
      "flashcard._id": 1//flashcardId
      
    }
  ]
})

Sample Mongo Playground

answered Nov 4, 2021 at 9:49

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

Comments

SirageDb · Accepted Answer · 2021-11-04 10:29:46Z

0

Although i accepted @yong shun which is the best approach, another way to do it in case you don't like mongoose syntax :


      const classroom = await classroomModel.findOne(
        {
          _id: 1 //classroomId,
        },
      )

      const subject = classroom.subject.find(
        (currentSubject: any) => {
          return currentSubject.subjectId == 1 //subjectId
        }
      )

      const flashcard = subject.flashcard.find(
        (currentFlashcard: any) => {
          return currentFlashcard._id == 1 //flashcardId
        }
      )
      flashcard.title = "my new title";
      await classroomModel.updateOne(classroom);

answered Nov 4, 2021 at 10:29

SirageDb

434 bronze badges

Collectives™ on Stack Overflow

Mongoose - Update an object inside nested array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related