Bulk write filter on an object array

[freeross]

I have the following (simplified) data:

db={
  Rankings: [
    {
      _id: ObjectId("62c66dc612296752b7c82cde"),
      players: [
        {
          playerId: "xyz1",
          challengerId: "abc1",
          rank: 1
        },
        {
          playerId: "abc1",
          challengerId: "xyz1",
          rank: 2
        }
      ],
      
    }
  ]
}

and I want to do a bulkWrite in the same document against rank 1 and 2 with expected output:

[
  {
    "_id": ObjectId("62c66dc612296752b7c82cde"),
    "players": [
      {
        "challengerId": null,
        "playerId": "abc1",
        "rank": 1
      },
      {
        "challengerId": null,
        "playerId": "xyz1",
        "rank": 2
      }
    ]
  }
]

For reference/context I believe my closest attempt so far is (simplified ids are now full ObjectIds, but the same swapping logic applies):

db.Rankings.bulkWrite([
      { updateOne : {
        //here the challenger is 62c2b79d966b72973fe52317, but he has won, so he
        //becomes 'player' in rank 1
         "filter" : { _id: ObjectId("62c66dc612296752b7c82cde"),
         
               input: "$players",
               as: "players",
               cond: { $eq: [ "$$players.ranking", 1 ] }},

         "update" : { $set : {  "players.playerId": ObjectId("62c2b79d966b72973fe52317"),
                                "players.challengerId": null
                    } }
      } }
      
      ,
      { updateOne : {
        //player from rank 1, is now player in rank 2
         "filter" : { _id: ObjectId("62c66dc612296752b7c82cde"), 
                input: "$players",
                as: "players",
                cond: { $eq: [ "$$players.ranking", 2 ] }},

         "update" : { $set : {  "players.playerId": ObjectId("62c2b79d966b72973fe52316"),
                                "players.challengerId": null
                    } }
      } }

   ])

This returns:

{
  "acknowledged": true,
  "insertedCount": 0,
  "insertedIds": {},
  "matchedCount": 0,
  "modifiedCount": 0,
  "deletedCount": 0,
  "upsertedCount": 0,
  "upsertedIds": {}
}

What should my “filter” syntax be to filter against rank in the players object array and achieve these updates? thanks …

[freeross]

The following is, I believe, closer, as “matchedCount” is now 1 (“modifiedCount” is still 0):

"filter": { _id: ObjectId("62c66dc612296752b7c82cde") },
"update": { $set: { "players.$[playerId]" : ObjectId("62c2b79d966b72973fe52317")} },
"arrayFilters": [ { playerId : ObjectId("62c2b79d966b72973fe52316") } ]

what do I need to change to set the playerId and therefore get ‘modifiedCount’ to 1? …

[freeross]

I fixed this thanks to this article in StackOverflow.
Here is the code for my case as detailed above:

db.rankings.bulkWrite([
      { updateMany : {
        //challenger, identified by ObjectId, has won, so his Id
        //becomes 'player.playerId' in rank 1
        //arrayFilters are used to match to the correct object to be updated in the player array
      "filter": { _id: ObjectId("62c66dc612296752b7c82cde") },
      "update": 
            { $set: { "players.$[player].playerId" : ObjectId("62c2b79d966b72973fe52317"),
            "players.$[player].challengerId" : null,
            "players.$[player].rank" : 1}
            },
      "arrayFilters": 
            [
                  {
                        "player.playerId": 
                        { 
                        $eq: ObjectId("62c2b79d966b72973fe52316")
                        }
                        ,
                        "player.challengerId": 
                        { 
                        $eq: ObjectId("62c2b79d966b72973fe52317")
                        }
                        ,
                        "player.rank": 
                        { 
                        $eq: 1
                        }
                  }
            ]
       }}
      ,
      { updateMany : {
        //player from rank 1, is now player in rank 2
      "filter": { _id: ObjectId("62c66dc612296752b7c82cde") },
      "update": 
            { $set: { "players.$[player].playerId" : ObjectId("62c2b79d966b72973fe52316"),
            "players.$[player].challengerId" : null,
            "players.$[player].rank" : 2}
            },
      "arrayFilters": 
            [
                  {
                        "player.playerId": 
                        { 
                        $eq: ObjectId("62c2b79d966b72973fe52317")
                        }
                        ,
                        "player.challengerId": 
                        { 
                        $eq: ObjectId("62c2b79d966b72973fe52316")
                        }
                        ,
                        "player.rank": 
                        { 
                        $eq: 2
                        }
                  }
            ]
      }}

   ])