how to insert an object into the players array in mongoDB?

Question

I have the document below and I need to insert an object into the players arrays how to do this with mongoDB

{
        "data": {
            "createTournament": {
                "_id": "6130d9a565aa744f173a824a",
                "title": "Jogo de truco",
                "description": "",
                "status": "PENDING",
                "size": 8,
                "prizePool": 20,
                "currency": "USD",
                "type": "Battle",
                "entryFee": 1,
                "startDate": "2021-09-01",
                "endDate": "2021-09-01",
                "rounds": [{
                    "round": 1,
                    "totalMatches": 4,
                    "matches": [{
                            "match": 1,
                            "players": []
                        }
                    ]
                }]
            }
        }
    }

First step: figure out how to do it via the shell. See stackoverflow.com/questions/27874469/… and stackoverflow.com/questions/36113069/… — Paul
– Paul, Commented Sep 2, 2021 at 16:44

mohammad Naimi · Accepted Answer · 2021-09-02 17:08:29Z

0

it will add 3 to array players that array matches has match of 1 and rounds array has round of 1

db.collection('exmaple').updateOne({},
{
      $push:{"data.createTournament.rounds.$[outer].matches.$[inner].players":"3"}
    },
    { "arrayFilters": [
      { "outer.round": 1 }, // you could change this to choose in which array must be pushed
      { "inner.match":1  } // // you could change this to choose in which array must be pushed
  ] }
)

answered Sep 2, 2021 at 17:08

mohammad Naimi

2,3591 gold badge7 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

how to insert an object into the players array in mongoDB?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related