MongoDB：无需$unwind从对象数组中提取指定字段

Got it, let's tackle this problem without relying on $unwind since it's causing performance bottlenecks when paired with $group. First, let's use a sample document to make this concrete:

// Sample document
{
  "_id": 1,
  "providers": [
    { "code": "ABC", "prvdId": "123" },
    { "code": "TRT", "prvdId": "456" },
    { "code": "XYZ", "prvdId": "789" }
  ]
}

Our goal is to extract the prvdId value where code equals "TRT"—all without exploding the array with $unwind.

Method 1: Using $filter + $map + $arrayElemAt #

This approach filters the array to isolate matching objects, maps them to just their prvdId values, then grabs the first result (assuming only one "TRT" entry exists):

db.collection.aggregate([
  {
    $project: {
      trtPrvdId: {
        $arrayElemAt: [
          {
            $map: {
              input: {
                $filter: {
                  input: "$providers",
                  cond: { $eq: ["$$this.code", "TRT"] }
                }
              },
              as: "item",
              in: "$$item.prvdId"
            }
          },
          0 // Grab the first matching prvdId
        ]
      }
    }
  }
])

Output: #

{ "_id": 1, "trtPrvdId": "456" }

If there are multiple "TRT" entries, remove the $arrayElemAt stage to get an array of all matching prvdId values instead.

Method 2: Simplified with $let (MongoDB 3.2+) #

For cleaner code, use $let to define a reusable variable for the filtered array, then directly extract the prvdId:

db.collection.aggregate([
  {
    $project: {
      trtPrvdId: {
        $let: {
          vars: {
            filteredTrtItems: {
              $filter: {
                input: "$providers",
                cond: { $eq: ["$$this.code", "TRT"] }
              }
            }
          },
          in: { $arrayElemAt: ["$$filteredTrtItems.prvdId", 0] }
        }
      }
    }
  }
])

This does the exact same thing as Method 1 but reads more like plain English.

Handling Cases Where "TRT" Doesn't Exist #

If some documents might not have a "TRT" entry, use $ifNull to return a default value instead of null:

in: { $ifNull: [{ $arrayElemAt: ["$$filteredTrtItems.prvdId", 0] }, "No TRT provider found"] }

Why This Is Better Than $unwind #

Unlike $unwind, which splits every array element into a separate document (creating huge intermediate datasets), these operations run entirely within each individual document. This avoids the overhead of splitting and re-grouping documents, making the aggregation much faster—especially with large collections or arrays.

内容的提问来源于stack exchange，提问作者vishwajith reddy