I have MongoDB users collection with the (simplified) document structure:

{
  _id: ObjectId,
  name: 'John Doe',
  sportsList: [ // array of objects
    {
      name: 'football',
      level: 1500,
      levelHistory: [ // array of objects
        {
          from: 1450,
          to: 1500,
          date: Date
        },
        ...
      ]
    },
    {
      name: 'tennis',
      level: 1400,
      levelHistory: [ // array of objects
        {
          from: 1350,
          to: 1400,
          date: Date
        },
        ...
      ]
    },
  ]
}

I want to update the element of sportsList that has the name === 'tennis' like this:

• push a new element into levelHistory
• update the level So far I've managed to push a new element into levelHistory with this query:

await User.updateOne(
  {
    _id: userId,
    sportsList: {
      $elemMatch: { name: 'tennis' }
    }
  },
  {
    $push: {
      'sportsList.$.levelHistory': {
        date: Date,
        from: 1400,
        to: 1450
      }
    },
    // how do I set 'level: 1450' in the same query?
    // if I tried to use a $set: { 'sportsList.$.level': 1450 } mongoDB throws an error
  }
)