MongoDB nggabung kondisi query nganggo operator logika — $and, $or, $not, $nor — ditambah implicit AND saka pirang-pirang field ing filter. Iki ngidini sampeyan ngekspresi logika query sing kompleks kanggo nemokake dokumen sing persis kang dibutuhno.
// multiple fields in one filter = AND (all must match)
db.users.find({ active: true, age: { $gt: 18 } });
// → active = true AND age > 18 (no explicit $and needed)
Kasus paling simpel: nalika nelisting pirang-pirang kondisi ing filter, iku implicit AND — kabeh kudu cocok.
// $or takes an array of conditions; a document matches if ANY is true
db.users.find({
$or: [
{ age: { $lt: 18 } },
{ age: { $gt: 65 } }
]
});
// → age < 18 OR age > 65
// usually implicit, but $and is needed when combining conditions on the SAME field
db.products.find({
$and: [
{ price: { $gt: 100 } },
{ price: { $lt: 500 } }
]
});
// (often you can write { price: { $gt: 100, $lt: 500 } } instead — cleaner)
// $and is also useful to combine $or groups:
db.users.find({
$and: [
{ $or: [{ role: "admin" }, { role: "editor" }] },
{ active: true }
]
});
db.products.find({ price: { $not: { $gt: 100 } } }); // NOT (price > 100) → price <= 100 or missing
db.users.find({ $nor: [{ active: true }, { premium: true }] }); // NEITHER condition true
// real queries combine logical + comparison operators
db.orders.find({
status: "shipped", // implicit AND
$or: [
{ total: { $gt: 1000 } },
{ priority: "high" }
]
});
// → status = shipped AND (total > 1000 OR priority = high)
Operator logika kuwi perlu banget kanggo ngekspresi kondisi query sing kompleks ing MongoDB — query nyata asring butuh luwih saka saiji-sijine kondisi (nggabung kondisi multi-condition nganggo logika AND/OR), dadi paham babagan iki kuwi pengetahuan dasar saben dina kanggo filter data kanthi epektif.
Gawe kowe ngerti implicit AND saka pirang-pirang field filter (kasus paling simpel, paling umum — nelisting kondisi sing kabeh kudu cocok), $or (cocok salah sawijining pirang-pirang kondisi — kebutuhan sing asring ana kanggo alternatif), $and (explicit AND, dibutuhke kanggo nggabung kondisi ing field sing padha utawa grouping klausa $or), lan $not/$nor (negasi) sing nyakup blok logika dasar kanggo ngekspresi requirement query.
Mahamake carane nggabung operator logika lan perbandingan (mbangun query kaya "status shipped AND (total > 1000 OR priority high)") kuwi perlu kanggo query multi-condition sing realistis sing aplikasi butuhke.
Amarga filter data nganggo kondisi gabungan kuwi kebutuhan sing umum (nemokake dokumen sing cocok kriteria kompleks), lan amarga operator logika MongoDB (implicit AND, $or, $and, $not/$nor) kuwi carane sampeyan ngekspresi logika iki — gabung karo operator perbandingan kanggo kondisi nyata — paham babagan operator logika kuwi pengetahuan MongoDB sing perlu, sering diterapke kanggo nulis query sing epektif, padha kaya ngopeni AND/OR/NOT ing klausa SQL WHERE, lan perlu kanggo nemokake persis dokumen sing kang dibutuhno nganggo kondisi sing asring kompleks sing aplikasi nyata butuhke.
Pustaka pitakon wawancara IT kanthi jawaban rinci — saka Junior nganti Senior.
Nyumbang