運算子 $minN 可用來根據指定的篩選準則擷取字段的下 N 個值。
語法
$minN: {
input: < field or expression > ,
n: < number of values to retrieve >
}
參數
| 參數 | Description |
|---|---|
input |
指定要評估最小值的欄位或表達式。 |
n |
指定要擷取的最小值數目。 必須是正整數。 |
範例
請參考商店集合中的此範例檔。
{
"_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:擷取下兩個銷售類別
此查詢會擷取每個銷售量最低的商店的底部兩個銷售類別。 在巢狀 salesCategory 字段上使用 $minN 運算符執行查詢。
db.stores.aggregate([{
$project: {
bottomSalesCategories: {
$minN: {
input: "$sales.salesByCategory",
n: 2
}
}
}
},
{
$limit: 4
}
])
此查詢會傳回下列結果:
[
{
"_id": "a715ab0f-4c6e-4e9d-a812-f2fab11ce0b6",
"bottomSalesCategories": [
{
"categoryName": "Stockings",
"totalSales": 25731
}
]
},
{
"_id": "923d2228-6a28-4856-ac9d-77c39eaf1800",
"bottomSalesCategories": [
{
"categoryName": "Lamps",
"totalSales": 19880
},
{
"categoryName": "Rugs",
"totalSales": 20055
}
]
},
{
"_id": "7e53ca0f-6e24-4177-966c-fe62a11e9af5",
"bottomSalesCategories": [
{
"categoryName": "Markers",
"totalSales": 3927
}
]
},
{
"_id": "44fdb9b9-df83-4492-8f71-b6ef648aa312",
"bottomSalesCategories": [
{
"categoryName": "Storage Boxes",
"totalSales": 2236
}
]
}
]
範例 2 - 搭配使用 $minN 搭配 $setWindowFields
若要依「第一次上線顧問」公司內所有商店的銷售量,取得銷售類別的下兩個清單,請先執行查詢,以依公司分割商店。 然後,使用 $minN 運算符來判斷每個數據分割內銷售額最低的兩個類別。
db.stores.aggregate([{
$match: {
company: {
$in: ["First Up Consultants"]
}
}
}, {
$setWindowFields: {
partitionBy: "$company",
sortBy: {
"sales.totalSales": -1
},
output: {
minTwoBySales: {
$minN: {
input: "$sales.totalSales",
n: 2
}
}
}
}
}, {
$project: {
company: 1,
name: 1,
minCategoriesBySales: 1
}
}])
此查詢傳回的第一個結果是:
[
{
"_id": "a0386810-b6f8-4b05-9d60-e536fb2b0026",
"name": "First Up Consultants | Electronics Stop - South Thelma",
"company": "First Up Consultants",
"minCategoriesBySales": [
[
{
"categoryName": "3D Printers",
"totalSales": 20882
},
{
"categoryName": "Phone Mounts",
"totalSales": 13624
},
{
"categoryName": "Prepaid Phones",
"totalSales": 7182
},
{
"categoryName": "MacBooks",
"totalSales": 10541
},
{
"categoryName": "Chargers",
"totalSales": 37542
},
{
"categoryName": "Student Laptops",
"totalSales": 43977
},
{
"categoryName": "Screen Protectors",
"totalSales": 14648
},
{
"categoryName": "Photo Printers",
"totalSales": 40064
},
{
"categoryName": "Printer Ink",
"totalSales": 30784
},
{
"categoryName": "Smartphone Cases",
"totalSales": 30468
},
{
"categoryName": "Printer Drums",
"totalSales": 34980
},
{
"categoryName": "Desktops",
"totalSales": 3890
}
],
[
{
"categoryName": "4K Camcorders",
"totalSales": 10466
},
{
"categoryName": "Tripods",
"totalSales": 30942
},
{
"categoryName": "Camcorder Accessories",
"totalSales": 25601
}
]
]
}
]
範例 3 - 使用 $minN 運算符作為 array-expression 來取得最低的兩個銷售值
此查詢會擷取特定商店文件的兩個最低銷售額值。
db.stores.aggregate([
{ $match: {_id: "40d6f4d7-50cd-4929-9a07-0a7a133c2e74"} },
{
$project: {
name: 1,
lowestTwoSales: {
$minN: {
input: "$sales.salesByCategory.totalSales",
n: 2
}
}
}
}
])
此查詢會傳回下列結果。
[
{
"_id": "40d6f4d7-50cd-4929-9a07-0a7a133c2e74",
"name": "Proseware, Inc. | Home Entertainment Hub - East Linwoodbury",
"lowestTwoSales": [28946, 3000]
}
]