Beginner LevelMongoDB & Mongoose
How do MongoDB query operators ($gt, $lt, $in, $and, $or) filter documents?
❓ Interview Prompt: Explain comparison operators ($eq, $gt, $gte, $lt, $lte, $in, $nin) and logical operators ($and, $or, $nor, $not).
MongoDB query operators enable precise field filtering and logical evaluation:
Comparison Operators:
•
'$gt' / '$gte': Greater than / Greater than or equal.
•
'$in': Matches any value in a specified target array.
Logical Operators:
•
'$and': Evaluates to true if all conditions match.
•
'$or': Evaluates to true if any condition matches.
Code Implementation Example
typescript
import { ProductModel } from './models/Product';
async function searchProducts() {
const products = await ProductModel.find({
$and: [
{ category: { $in: ['electronics', 'computers'] } },
{ price: { $gte: 100, $lte: 1000 } },
{ $or: [{ inStock: true }, { isPreorder: true }] }
]
});
return products;
}💡Combining comparison ($in, $gte) and logical ($and, $or) query operators.
🎯 Interview Key Takeaway
Use comparison ($gt, $in) and logical ($and, $or) operators to construct complex MongoDB filtering criteria.
#Query Operators#$in#$or#$gt#Beginner
Back to all MongoDB & Mongoose Questions→