MongoDB Queries, Projection, Sort, and Pagination

db.orders.find({ total: { $gte: 100, $lte: 500 } })

# Filter with range operators.

db.orders.find({ status: { $in: ["paid", "shipped"] } })

# Filter using `$in`.

db.orders.find({ $or: [{ priority: "high" }, { total: { $gt: 1000 } }] })

# Match one of several conditions.

db.orders.find({ shipped_at: { $exists: false } })

# Find documents that have or do not have a field.

db.users.find({ email: /@example\.com$/i })

# Search string values with a regular expression.

db.users.find({ active: true }, { name: 1, email: 1, _id: 0 })

# Return only specific fields from matches.

db.orders.find().sort({ created_at: -1 })

# Sort descending on a field.

db.orders.find().sort({ created_at: -1 }).limit(20)

# Return only a fixed number of documents.

db.orders.find().sort({ created_at: -1 }).skip(40).limit(20)

# Page through results with skip and limit.

db.orders.find({ _id: { $lt: ObjectId("65f0c8d4d95f1b2a3c4d5e6f") } }).sort({ _id: -1 }).limit(20)

# Use a stable sort key such as `_id` or a timestamp.