Mongo DB :- Specify AND & OR Conditions

In this post I am going to explain how to Specify AND & OR Conditions from Mongo DB collection . for this as a sample data you have to upload data into mongo db database.

db.inventory.insertMany([
   { item: "journal", qty: 25, size: { h: 14, w: 21, uom: "cm" }, status: "A" },
   { item: "notebook", qty: 50, size: { h: 8.5, w: 11, uom: "in" }, status: "A" },
   { item: "paper", qty: 100, size: { h: 8.5, w: 11, uom: "in" }, status: "D" },
   { item: "planner", qty: 75, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" },
   { item: "postcard", qty: 45, size: { h: 10, w: 15.25, uom: "cm" }, status: "A" }
]);

In the following example, the compound query document selects all documents in the collection where the status equals "A" and either qty is less than ($lt) 30 or item starts with the character p:

Then you can execute below query.

db.inventory.find( {status: "A“,$or: [ { qty: { $lt: 30 } }, { item: /^p/ } ]} )

Above selection command is identical to

SELECT * FROM inventory WHERE status = 'A' AND ( qty < 30 OR item LIKE 'p%');

 in the SQL

Thank You !!!