How to select where sum of fields is greater than a value in MongoDB
The easiest way to do this is by using $where (I am not telling that it is not possible to do this with aggregation)
db.table.find({$where: function() {
return this.field1 + this.field2 + this.field3 > 1
// most probably you have to handle additional cases if some of the fields do not exist.
}}
The pros of it is that it is easy and intuitive, whereas cons:
requires that the database processes the JavaScript expression or function for each document in the collection.
If you need to perform this kind of searches often, I would go ahead and create a new field which will have a sum of 3 fields stored in it and put an index on it. The downside is that you have to increase your app logic.
> db.test.drop()
> db.test.insert({ "_id" : 0, "a" : 1, "b" : 1, "c" : 1 })
> db.test.insert({ "_id" : 1, "a" : 1, "b" : 1, "c" : 2 })
> db.test.aggregate([
{ "$project" : {
"sum" : { "$add" : ["$a", "$b", "$c" ] }
} },
{ "$match" : {
"sum" : { "$gte" : 4 }
} }
])
{ "_id" : 1, "sum" : 4 }