MongoDB update inside array of object of array of object

Question

Test Data:-

professor:{
 name:"temp1",
 department:[
 {name:"pro1",
 review:[
 {paper:"paper1",status:"review",paperid:"1"}
 ]}]}

I want to update the status "review" to "finish". For to search I use :

 {
department: {
                $elemMatch: {
                  review: {
                    $elemMatch: {
                      paperid: id
                    }
                  }
                }
          }}

nimrod serok · Accepted Answer · 2022-06-19 10:03:13Z

1

If you want to update all your documents where the status is review use:

db.collection.update(
  {},
  {$set: {"professor.department.$[].review.$[r].status": "finish"}},
  {arrayFilters: [{"r.status": "review"}]}
)

See how it works on the playground example

If you want to update only where the department.name is pro1 use:

db.collection.update(
  {},
  {$set: {"professor.department.$[d].review.$[r].status": "finish"}},
  {arrayFilters: [{"d.name": "pro1"}, {"r.status": "review"}]}
)

See how it works on the playground example - department

edited Jun 19, 2022 at 10:03

answered Jun 19, 2022 at 9:57

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

Comments

DayDreamer · Accepted Answer · 2022-06-20 06:11:20Z

0

by specify paperid

db.collection.updateOne(
    {},
    {
        $set: { "professor.department.$[].review.$[r].status": 'finish' }
    },
    {
        arrayFilters: [{ "r.paperid": '1' }]
    }
)

answered Jun 20, 2022 at 6:11

DayDreamer

1165 bronze badges

Collectives™ on Stack Overflow

MongoDB update inside array of object of array of object

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related