$minN

運算子 $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]
    }
]