How to search for documents based on the value of adding two properties in MongoDB?

You can use aggregate framework for this. Here, we will get the sum and then match it to search for documents less than a particular number. Let us first create a collection with documents −

> db.searchDocumentsDemo.insertOne({"Value1":100,"Value2":560});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cd3fe1eedc6604c74817ce9")
}
> db.searchDocumentsDemo.insertOne({"Value1":300,"Value2":150});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cd3fe29edc6604c74817cea")
}
> db.searchDocumentsDemo.insertOne({"Value1":400,"Value2":200});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cd3fe30edc6604c74817ceb")
}
> db.searchDocumentsDemo.insertOne({"Value1":190,"Value2":210});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cd3fe45edc6604c74817cec")
}

Following is the query to display all documents from a collection with the help of find() method −

> db.searchDocumentsDemo.find().pretty();

This will produce the following output −

{
   "_id" : ObjectId("5cd3fe1eedc6604c74817ce9"),
   "Value1" : 100,
   "Value2" : 560
}
{
   "_id" : ObjectId("5cd3fe29edc6604c74817cea"),
   "Value1" : 300,
   "Value2" : 150
}
{
   "_id" : ObjectId("5cd3fe30edc6604c74817ceb"),
   "Value1" : 400,
   "Value2" : 200
}
{
   "_id" : ObjectId("5cd3fe45edc6604c74817cec"),
   "Value1" : 190,
   "Value2" : 210
}

Following is the query to search for documents based on the value of adding two properties on the document −

> db.searchDocumentsDemo.aggregate([
...   { $project: {totalValue: { $add: [ "$Value1", "$Value2" ] } } },
...   { $match: {totalValue: {$lt: 500 }} }
... ]);

This will produce the following output −

{ "_id" : ObjectId("5cd3fe29edc6604c74817cea"), "totalValue" : 450 }
{ "_id" : ObjectId("5cd3fe45edc6604c74817cec"), "totalValue" : 400 }

Nishtha Thakur

Updated on 30-Jul-2019 22:30:26

• Related Questions & Answers
• Search for multiple documents in MongoDB?
• Aggregate based on array value to sum values in different MongoDB documents?
• How to filter documents based on an array in MongoDB?
• Querying array of Embedded Documents in MongoDB based on Range?
• Search for documents with similar arrays in MongoDB and order by similarity value
• MongoDB Regex Search on Integer Value?
• Update quantity in MongoDB based on two conditions?
• How can I count the documents in an array based on the value of a specific field?
• How can I find documents in MongoDB based on the number of matched objects within an array?
• How to search documents through an integer array in MongoDB?
• Search for documents matching first item in an array with MongoDB?
• MongoDB aggregation to sum individual properties on an object in an array across documents
• JavaScript Separate objects based on properties
• How can I search a collection to find a nested value in one of its documents in MongoDB?
• Check for existing documents/embedded documents in MongoDB