Hi, My collection has objects that are like this: { totalWins: 12, seasons: { 1: { wins: 10 }, 2: { wins: 2 } } } I want to sum the wins from the seasons objects and put that sum into the field totalWins. However, it is possible …

Hello : ) Storing unknown keys in documents,its not good idea i think,because we will have to find those keys to sum them. With arrays we don’t find them,and mongo offers so many array operations. Why not store an array,if all seasons exist 1,2,3 … you dont even need the field season. The index…

Updating field by summing values

Working with Data

Prasad_Saya (Prasad Saya) October 5, 2020, 6:55am 12

See this post, which uses $set (aggregation) on Java with mongo-java-driver/4.0/ . You need to use this Java driver API for update with aggregation: updateMany.