MongoDB Query สำหรับ Boolean Field เป็น "Not True"

Query Boolean Field ที่ไม่ใช่ True ด้วย $ne

ใช้ Operator $ne (Not Equal) เพื่อค้นหา Document ที่ Boolean Field ไม่ใช่ True

db.yourCollectionName.find({yourFieldName: {$ne: true}}).pretty();

สร้างข้อมูลตัวอย่าง

> db.queryForBooleanFieldsDemo.insertOne({"EmployeeName":"Larry","EmployeeAge":24,"isOldEmployee":true});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8b7f7680f10143d8431e13") }
> db.queryForBooleanFieldsDemo.insertOne({"EmployeeName":"Mike","EmployeeAge":20,"isOldEmployee":false});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8b7f8680f10143d8431e14") }
> db.queryForBooleanFieldsDemo.insertOne({"EmployeeName":"Sam","EmployeeAge":23,"isOldEmployee":false});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8b7f9380f10143d8431e15") }
> db.queryForBooleanFieldsDemo.insertOne({"EmployeeName":"David","EmployeeAge":25,"isOldEmployee":true});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8b7fa280f10143d8431e16") }
> db.queryForBooleanFieldsDemo.insertOne({"EmployeeName":"Carol","EmployeeAge":27,"isOldEmployee":true});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8b7fae80f10143d8431e17") }

แสดงข้อมูลทั้งหมด

> db.queryForBooleanFieldsDemo.find().pretty();

{ "_id" : ObjectId("5c8b7f7680f10143d8431e13"), "EmployeeName" : "Larry", "EmployeeAge" : 24, "isOldEmployee" : true }
{ "_id" : ObjectId("5c8b7f8680f10143d8431e14"), "EmployeeName" : "Mike", "EmployeeAge" : 20, "isOldEmployee" : false }
{ "_id" : ObjectId("5c8b7f9380f10143d8431e15"), "EmployeeName" : "Sam", "EmployeeAge" : 23, "isOldEmployee" : false }
{ "_id" : ObjectId("5c8b7fa280f10143d8431e16"), "EmployeeName" : "David", "EmployeeAge" : 25, "isOldEmployee" : true }
{ "_id" : ObjectId("5c8b7fae80f10143d8431e17"), "EmployeeName" : "Carol", "EmployeeAge" : 27, "isOldEmployee" : true }

Query พนักงานที่ isOldEmployee ไม่ใช่ true

> db.queryForBooleanFieldsDemo.find({isOldEmployee: {$ne: true}}).pretty();

{ "_id" : ObjectId("5c8b7f8680f10143d8431e14"), "EmployeeName" : "Mike", "EmployeeAge" : 20, "isOldEmployee" : false }
{ "_id" : ObjectId("5c8b7f9380f10143d8431e15"), "EmployeeName" : "Sam", "EmployeeAge" : 23, "isOldEmployee" : false }