Mongo DB :- Specify AND Conditions

In this post I am going to explain how to Specify AND 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" }
]);

A compound query can specify conditions for more than one field in the collection’s documents. 

Implicitly, a logical AND conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions.

Then you can execute below query.

db.inventory.find( { status: "A", qty: { $lt: 30 } } )

Above selection command is identical to

SELECT * FROM inventory WHERE status = 'A' AND qty < 30;

 in the SQL

Thank You !!!