How to fetch documents with condition on $sum that it should not cross the limit specified

[Pavel_Duchovny]

Hi @Tiya_Jose,

Seems like a similar request was made earlier:

Aggregate $sum with condition on sum limit in mongo query

I have requirement to update the data based on the inputs using recordID , each recordID has count of associated records. since associated records has huge volume of data , I wanted to control the number of update based on the associated records count via configuration. So in the query, i want to sum the associated document count and should not cross limit configured in property. I wanted to fetch the records using $sum (aggregation) operation in the aggregate query but not sure how to add the c…

Consider reading it and let us know if you have questions

Thanks
Pavel