I want to increment all documents in a collection that contain a given nested array value. My objects each contain an "order" array with key:number values.
{
_id: ...,
order : array(
foo: 34
)
}
However, I can't figure out the correct MongoDB Query using the PHP MongoDB Native Driver.
// Update all existing items with an order greater than this number
$number = 2;
$result = $collection->update(
array("order" => array('foo' => array('$gt' => $number))),
array('$inc' => array('order' => array('foo' => 1))),
array("safe" => true)
);