[{"_id":{"$oid":"6398c34ca67dbe3286452f23"},"name":"test","createdBy":{"$oid":"636c1778f1d09191074f9690"},"description":"testing","date":{"$date":{"$numberLong":"1645488000000"}},"location":{"type":"Point","coordinates":[0,0]},"weights":[{"spotsAvailable":[{"name":"empty","userId":"empty"},{"name":"empty","userId":"empty"},{"name":"empty","userId":"empty"}],"weight":12},{"spotsAvailable":[{"name":"empty","userId":"empty"},{"name":"empty","userId":"empty"}],"weight":15}],"eventApplicants":[{"userId":{"$oid":"636c1778f1d09191074f9690"},"name":"Wayne Wrestler","weight":12}]}]

db.collection.aggregate([{$match:{"_id":ObjectId("6398c34ca67dbe3286452f23"),createdBy:ObjectId("636c1778f1d09191074f9690"),"weights.weight":12,"weights.spotsAvailable.userId":"empty"}},{"$unwind":"$weights"},{"$addFields":{"results":{"$reduce":{"input":"$weights.spotsAvailable","initialValue":{result:[],updated:false},"in":{"$cond":{"if":{$and:[{$eq:[false,"$$value.updated"]},{$eq:["empty","$$this.userId"]}]},"then":{result:{"$concatArrays":["$$value.result",[{"name":"Wayne Wrestler","userId":ObjectId("636c1778f1d09191074f9690")}]]},updated:true},"else":{result:{"$concatArrays":["$$value.result",["$$this"]]},updated:"$$value.updated"}}}}}}},{$set:{"weights.spotsAvailable":"$results.result","results":"$$REMOVE"}},{$group:{_id:"$_id","name":{$first:"$name"},"createdBy":{$first:"$createdBy"},"description":{$first:"$description"},"date":{$first:"$date"},"location":{$first:"$location"},"weights":{$push:"$weights"},"eventApplicants":{$first:"$eventApplicants"}}},{"$merge":{"into":"collection","on":"_id"}}])