mongodb上的arrayFilters php更新[重复]

Question

This question already has an answer here:

• How to Update Multiple Array Elements in mongodb 13 answers

I want to update many documents on my db but are nested arrays so I need to use arrayFilters. In the shell works perfect but in my php code never works. I have tried this way:

$command = new \MongoDB\Driver\Command(
  [
    'update'  => 'students2',
    'updates' => [["grades.grade" => ['$gte' => 85]], ['$set' => ["grades.$[elem].mean" => 98 ]], 'arrayFilters'   => $filters, 'multi' => true]
  ]
);

with error: BSON field 'update.updates.grades.grade' is an unknown field

this way:

$db->students2->updateMany([],['$set'=>["grades.$[elem].mean" => 100 ]],['arrayFilters'=>  ["elem.grade"=> ['$gte'=>85 ]]]);

with error: "arrayFilters" option has invalid keys for a BSON array

If I execute this command works right but only in one document:

$command = new \MongoDB\Driver\Command(
  [
    'findAndModify'  => 'students2',
    'query'          => ["grades.grade" => ['$gte' => 85]],
    'update'         => ['$set' => ["grades.$[elem].mean" => 98 ]],
    'upsert'         => true,
    'returnDocument' => true,
    'new'            => true,
    'arrayFilters'   => [['elem.grade'] => ['$gte' => 85]]
  ]
);

this is my data in mongodb table:

{
   "_id" : 1,
   "grades" : [
      { "grade" : 80, "mean" : 75, "std" : 6 },
      { "grade" : 85, "mean" : 100, "std" : 4 },
      { "grade" : 85, "mean" : 100, "std" : 6 }
   ]
}
{
   "_id" : 2,
   "grades" : [
      { "grade" : 90, "mean" : 100, "std" : 6 },
      { "grade" : 87, "mean" : 100, "std" : 3 },
      { "grade" : 85, "mean" : 100, "std" : 4 }
   ]
}

What am I doing wrong? Thanks so much

</div>

Answer 1

Try This way

$updateResult = $collection->updateMany(
    ["inspector" => "J. Clouseau", "Sector" => 4 ],
    ['$set' => ['Patrolling' => false]]
);