Jul 20, 2016

Less than and Less than equals to query in MongoDB


To fetch records “less than” and “less than equals to” to specific value mongodb provide $lt and $lte operator respectively.

Syntax:


{ field: { $lt: value} } // for greater than
{ field: { $lte: value} } // for greater than equals to


Example: Suppose we have a collection “Order” now we want to fetch those documents which quantity is less than or less than equals to 4.


{ "_id" : 1, "item" : "item1", "qty" : 1, "Price" : 500 }
{ "_id" : 2, "item" : "item1", "qty" : 2, "Price" : 200 }
{ "_id" : 3, "item" : "item1", "qty" : 4, "Price" : 300 }
{ "_id" : 4, "item" : "item1", "qty" : 8, "Price" : 700 }
{ "_id" : 5, "item" : "item1", "qty" : 2, "Price" : 500 }


Query


db.Order.find({"qty":{$lt:4}}) // for less than
db.Order.find({"qty":{$lte:4}}) // for less than equals to


Results respectively


{ "_id" : 1, "item" : "item1", "qty" : 1, "Price" : 500 }
{ "_id" : 2, "item" : "item1", "qty" : 2, "Price" : 200 }
{ "_id" : 5, "item" : "item1", "qty" : 2, "Price" : 500 }



{ "_id" : 1, "item" : "item1", "qty" : 1, "Price" : 500 }
{ "_id" : 2, "item" : "item1", "qty" : 2, "Price" : 200 }
{ "_id" : 3, "item" : "item1", "qty" : 4, "Price" : 300 }
{ "_id" : 5, "item" : "item1", "qty" : 2, "Price" : 500 }