Hi.
First of all sorry for that unclear topic name.
I have two collections: players and scores. Everyday some players (not all of them) score points. I keep track of total_points (which are updated at instance whenever a player score points) in score collection. In scores collection documents are “grouped” per day (every day a new document is created), i.e., day: {list of {player: total_points}.
The problem: If the player didn’t score any points/did not play for that day and his score is not updated than the total_points from previous day should be copied to the new day document.
The tricky part: I can’t use Atlas (triggers) and I would prefer to do that with build-in Mongo tools instead of in my application code.
Thanks!