MongoDB Aggregation Framework ใช้ $match กับ $or ได้หรือไม่

การใช้ $match กับ $or ใน Aggregation Pipeline

สามารถใช้ Operator $or ภายใน Stage $match ของ Aggregation Framework ได้

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

> db.aggregationFrameworkWithOrMatchDemo.insertOne({"StudentFirstName":"John", "StudentLastName":"Smith","StudentAge":23});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8ac3a96cea1f28b7aa080d") }
> db.aggregationFrameworkWithOrMatchDemo.insertOne({"StudentFirstName":"Carol", "StudentLastName":"Tayor","StudentAge":24});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8ac3bc6cea1f28b7aa080e") }
> db.aggregationFrameworkWithOrMatchDemo.insertOne({"StudentFirstName":"David", "StudentLastName":"Miller","StudentAge":21});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8ac3ce6cea1f28b7aa080f") }
> db.aggregationFrameworkWithOrMatchDemo.insertOne({"StudentFirstName":"Bob", "StudentLastName":"Taylor","StudentAge":20});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8ac3e16cea1f28b7aa0810") }
> db.aggregationFrameworkWithOrMatchDemo.insertOne({"StudentFirstName":"Robert", "StudentLastName":"Smith","StudentAge":20});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8ac3fb6cea1f28b7aa0811") }
> db.aggregationFrameworkWithOrMatchDemo.insertOne({"StudentFirstName":"Mike", "StudentLastName":"Miller","StudentAge":27});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8ac4166cea1f28b7aa0812") }

Aggregation ด้วย $match และ $or

> db.aggregationFrameworkWithOrMatchDemo.aggregate({
  $match: { $or: [{ StudentLastName: 'Smith' }, { StudentLastName: 'Miller' }] }
}).pretty();

{ "_id" : ObjectId("5c8ac3a96cea1f28b7aa080d"), "StudentFirstName" : "John", "StudentLastName" : "Smith", "StudentAge" : 23 }
{ "_id" : ObjectId("5c8ac3ce6cea1f28b7aa080f"), "StudentFirstName" : "David", "StudentLastName" : "Miller", "StudentAge" : 21 }
{ "_id" : ObjectId("5c8ac3fb6cea1f28b7aa0811"), "StudentFirstName" : "Robert", "StudentLastName" : "Smith", "StudentAge" : 20 }
{ "_id" : ObjectId("5c8ac4166cea1f28b7aa0812"), "StudentFirstName" : "Mike", "StudentLastName" : "Miller", "StudentAge" : 27 }

ผลลัพธ์แสดง Document ที่มี StudentLastName เป็น "Smith" หรือ "Miller" ทั้งหมด 4 รายการ