Sum data from other collection

Working with Data
, ,
1

I’m new to MongoDb.
I need to calculate sum for each document using another collection.

Inefficient way will be:

		const farmers = await Farmer.find();
		for (let Farmers of farmers) {
			let farmerBusineesPlans = await BusinessPlan.find({
				farmerId: Farmers.id
			});
			for (let BusinessPlan of farmerBusineesPlans) {
				totalBusinessPlansSize =
					totalBusinessPlansSize + BusinessPlan.totalFieldSize;
			}
			Farmers.totalBusinessPlansSize = totalBusinessPlansSize;
			totalBusinessPlansSize = 0;
		}

I tried to aggregate like the following code, but I get an empty array in the “totalFieldSize” field.

		const farmers = await Farmer.aggregate([{
			$lookup:
				{
					from: 'BusinessPlans',
					localField: 'farmerId',
					foreignField: 'id',
					as: 'totalFieldSize'
				}
		}]);

What am I doing wrong?

Thanks in advanced, Yaakov.

2

May be it is simply a typing error.

In the JS loop, you have BusinessPlan without terminal s and in aggregation you use BusinessPlans with a terminal s.

3

Thanks @steevej
I expected to get error messages on wrong ids. Now I know :slight_smile:
Yaakov.

1 Like