運算$min子用於聚集階段,例如 $group、 $bucket$bucketAuto、 或 $setWindowFields。 min 運算子在總結資料或尋找資料集中的最小值時特別有用。
當用作欄位更新運算子時, $min 如果指定的值小於欄位的現行值,則運算子會將欄位的值更新為指定的值。 如果欄位不存在, $min 請建立 欄位,並將它設定為指定的值。
語法
$min: <expression>
<expression>可以是欄位路徑或匯總運算式,指定要針對最小計算考慮的值。
身為欄位更新運算子:
{
$min: {
<field1>: <value1>,
<field2>: <value2>,
...
}
}
參數
| 參數 | Description |
|---|---|
<expression> |
指定要判斷最小值的欄位或計算值。 |
身為欄位更新運算子:
| 參數 | Description |
|---|---|
field |
要以最小值更新的功能變數名稱。 |
value |
要與目前域值比較的值。 只有在此值較小時,才會更新欄位。 |
範例
請參考商店集合中的此範例檔。
{
"_id": "7954bd5c-9ac2-4c10-bb7a-2b79bd0963c5",
"name": "Lakeshore Retail | DJ Equipment Stop - Port Cecile",
"location": {
"lat": 60.1441,
"lon": -141.5012
},
"staff": {
"totalStaff": {
"fullTime": 2,
"partTime": 0
}
},
"sales": {
"salesByCategory": [
{
"categoryName": "DJ Headphones",
"totalSales": 35921
}
],
"fullSales": 3700
},
"promotionEvents": [
{
"eventName": "Bargain Blitz Days",
"promotionalDates": {
"startDate": {
"Year": 2024,
"Month": 3,
"Day": 11
},
"endDate": {
"Year": 2024,
"Month": 2,
"Day": 18
}
},
"discounts": [
{
"categoryName": "DJ Turntables",
"discountPercentage": 18
},
{
"categoryName": "DJ Mixers",
"discountPercentage": 15
}
]
}
],
"tag": [
"#ShopLocal",
"#SeasonalSale",
"#FreeShipping",
"#MembershipDeals"
],
"company": "Lakeshore Retail",
"city": "Port Cecile",
"lastUpdated": {
"$date": "2024-12-11T10:21:58.274Z"
}
}
範例 1:在 中使用$min$group
此查詢會先依銷售類別將文件分組,然後計算每個類別內的最小銷售量,以計算陣列中 sales.salesByCategory 每個類別的最小銷售量。
db.stores.aggregate([{
$unwind: "$sales.salesByCategory"
},
{
$group: {
_id: "$sales.salesByCategory.categoryName",
minSales: {
$min: "$sales.salesByCategory.totalSales"
}
}
}
])
此查詢會傳回下列結果。
[
{
"_id": "Christmas Trees",
"minSales": 391
},
{
"_id": "Nuts",
"minSales": 257
},
{
"_id": "Camping Tables",
"minSales": 171
},
{
"_id": "Music Theory Books",
"minSales": 323
},
{
"_id": "Fortified Wine",
"minSales": 521
},
{
"_id": "Children's Mystery",
"minSales": 1470
},
{
"_id": "Short Throw Projectors",
"minSales": 111
},
{
"_id": "Pliers",
"minSales": 1981
},
{
"_id": "Bluetooth Headphones",
"minSales": 465
},
{
"_id": "Video Storage",
"minSales": 1568
},
{
"_id": "Cleansers",
"minSales": 170
},
{
"_id": "Camera Straps",
"minSales": 127
},
{
"_id": "Carry-On Bags",
"minSales": 149
},
{
"_id": "Disinfectant Wipes",
"minSales": 647
},
{
"_id": "Insignia Smart TVs",
"minSales": 451
},
{
"_id": "Toner Refill Kits",
"minSales": 3525
},
{
"_id": "iPads",
"minSales": 325
},
{
"_id": "Storage Baskets",
"minSales": 1151
},
{
"_id": "Memory Foam Mattresses",
"minSales": 422
},
{
"_id": "Body Spray",
"minSales": 448
}
]
範例 2:在 中使用$min$bucket
此查詢會根據銷售值建立儲存貯體,並計算每個儲存貯體的最小銷售值。
db.stores.aggregate([{
$bucket: {
groupBy: "$sales.totalSales",
boundaries: [0, 1000, 5000, 10000],
default: "Other",
output: {
minSales: {
$min: "$sales.totalSales"
}
}
}
}])
此查詢會傳回下列結果。
[
{
"_id": 1000,
"minSales": 1000
},
{
"_id": "Other",
"minSales": null
},
{
"_id": 0,
"minSales": 108
},
{
"_id": 5000,
"minSales": 5001
}
]
範例 3:在 中使用$min$setWindowFields
此查詢會擷取 2023 年各公司「筆記型電腦」的最低折扣:
db.stores.aggregate([{
$unwind: "$promotionEvents"
},
{
$unwind: "$promotionEvents.discounts"
},
// Filter only Laptops category and events in 2023
{
$match: {
"promotionEvents.promotionalDates.startDate.Year": 2023,
"promotionEvents.discounts.categoryName": "Laptops"
}
},
// Use $setWindowFields to calculate average discount by city
{
$setWindowFields: {
partitionBy: "$company",
output: {
minDiscount: {
$min: "$promotionEvents.discounts.discountPercentage",
window: {
documents: ["unbounded", "unbounded"]
}
}
}
}
},
// Group by city to return one result per city
{
$group: {
_id: "$company",
minDiscount: {
$first: "$minDiscount"
}
}
}
])
此查詢會傳回下列結果。
[
{
"_id": "VanArsdel, Ltd.",
"minDiscount": 6
},
{
"_id": "Proseware, Inc.",
"minDiscount": 8
},
{
"_id": "Fabrikam, Inc.",
"minDiscount": 5
},
{
"_id": "Contoso, Ltd.",
"minDiscount": 5
},
{
"_id": "Fourth Coffee",
"minDiscount": 6
},
{
"_id": "Trey Research",
"minDiscount": 7
},
{
"_id": "Adatum Corporation",
"minDiscount": 5
},
{
"_id": "Relecloud",
"minDiscount": 5
},
{
"_id": "Lakeshore Retail",
"minDiscount": 7
},
{
"_id": "Northwind Traders",
"minDiscount": 8
},
{
"_id": "First Up Consultants",
"minDiscount": 9
},
{
"_id": "Wide World Importers",
"minDiscount": 10
},
{
"_id": "Tailwind Traders",
"minDiscount": 5
}
]
範例 4:設定最低員工需求 (欄位更新操作員)
若要設定最低人員需求,請僅在欄位的目前值較高時才更新全職標記計數。 由於目前的 fullTime 值為 14,而 10 小於 14,因此字段會更新為 10。
db.stores.updateOne(
{ _id: "26afb024-53c7-4e94-988c-5eede72277d5" },
{
$min: {
"staff.totalStaff.fullTime": 10
}
}
)
範例 5:多個欄位更新 (欄位更新運算子)
若要同時更新具有最小值的多個欄位,請使用具有多個欄位和對應最小值的$min運算子。
db.stores.updateOne(
{ _id: "26afb024-53c7-4e94-988c-5eede72277d5" },
{
$min: {
"staff.totalStaff.partTime": 12,
"sales.totalSales": 50000
}
}
)
在此案例中:
-
partTime(8) 自 12 > 8 日起更新為 8 (無變更) -
totalSales(83865) 自 50000 83865 年以來將更新為 50000 < 83865
範例 6:建立新欄位 (欄位更新運算子)
如果欄位不存在, $min 請使用指定的值加以建立。
db.stores.updateOne(
{ _id: "26afb024-53c7-4e94-988c-5eede72277d5" },
{
$min: {
"staff.minStaffRequired": 15,
"sales.minimumSalesTarget": 30000
}
}
)
範例 7:使用日期 (欄位更新運算子)
設定追蹤最早事件的最小日期。
db.stores.updateOne(
{ _id: "26afb024-53c7-4e94-988c-5eede72277d5" },
{
$min: {
"lastInventoryCheck": new Date("2024-01-15"),
"firstSaleDate": new Date("2023-06-01")
}
}
)
範例 8:更新陣列元素 (欄位更新運算子)
使用位置運算子更新陣列元素內的最小值。
db.stores.updateOne(
{
_id: "26afb024-53c7-4e94-988c-5eede72277d5",
"sales.salesByCategory.categoryName": "Lavalier Microphones"
},
{
$min: {
"sales.salesByCategory.$.totalSales": 40000
}
}
)
在這些欄位更新作業之後,更新的文件為:
{
"_id": "26afb024-53c7-4e94-988c-5eede72277d5",
"name": "First Up Consultants | Microphone Bazaar - South Lexusland",
"staff": {
"totalStaff": {
"fullTime": 10,
"partTime": 8
},
"minStaffRequired": 15
},
"sales": {
"totalSales": 50000,
"minimumSalesTarget": 30000,
"salesByCategory": [
{
"categoryName": "Lavalier Microphones",
"totalSales": 40000
},
{
"categoryName": "Wireless Microphones",
"totalSales": 39691
}
]
},
"lastInventoryCheck": ISODate("2024-01-15T00:00:00.000Z"),
"firstSaleDate": ISODate("2023-06-01T00:00:00.000Z")
}