Mongodb filter query if sum of the array is greater than X

Question

I am trying to find sum of the array fields and after that, want to filter these sums are greater than 100.

{
  name: 'John',
  grades: [60, 70, 40]     # sum of this array = 170 (take this)
},
{
  name: 'Doe',
  grades: [30, 20, 10]     # sum of this array = 60 (don't take this)
}

I made the projection of this collection like this:

db.collections.find({}, {
{
  sumOfGrades: { $sum: "$grades" }
})

// returns

{...sumOfGrades: 170}, {...sumOfGrades: 60}

// But I am trying to get the first doc(which is greater than 100) on mongoDB layer.

Takis · Accepted Answer · 2021-12-25 22:24:27Z

1

Query

you can do it with aggregation in easy way
sum the grades, and only those > 100 pass the match

*the filter is to keep or not document, project is to keep or not part of the document in general

Test code here

aggregate([{"$match":{"$expr":{"$gt":[{"$sum":"$grades"}, 100]}}}])

answered Dec 25, 2021 at 22:24

Takis

8,7552 gold badges17 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mongodb filter query if sum of the array is greater than X

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related