Skip to main content

Simple Query

Populate inventory collection with the data to start using find query.

db.inventory.insertMany([
   { item: "journal", qty: 25, status: "L" },
   { item: "notebook", qty: 50, status: "A" },
   { item: "paper", qty: 100, status: "H" },
   { item: "planner", qty: 75, status: "A" },
   { item: "postcard", qty: 45, status: "L" },
   { item: "bluebook", qty: 100, status: "H" },
   { item: "dbbook", qty: 75, status: "A" },
   { item: "bookmark", qty: 45, status: "L" }
]);

Find all​

Get all records from inventory

const cursor = db.collection('inventory').find({});

Equality condition​

Get records from inventory with the status equals "D"

const cursor = db.collection('inventory').find({ status: 'D' });

AND condition​

Get records from inventory with the status equals "D" AND qty less than 30.

const cursor = db.collection('inventory').find({
    status: 'A',
    qty: { $lt: 30 },
});

OR condition​

Get records from inventory with the status equals "A" OR qty less than 30.

const cursor = db.collection('inventory').find({
    status: 'A',
    qty: { $lt: 30 },
});