MongoDB:从数组中单独获取所有 $matched 元素

Question

我试图单独获取所有匹配的元素，here是示例数据和查询。

// json
[
  {
    "name": "Mr Cool",
    "ican": [
      {
        "subcategory": [
          {
            "id": "5bffdba824488b182ec86f8d", "name": "Cricket"
          },
          {
            "id": "5bffdba824488b182ec86f8c", "name": "Footbal"
          }
        ],
        "category": "5bffdba824488b182ec86f88",
        "name": "Sports"
      }
    ]
  }
]

// query
db.collection.aggregate([
  {
    "$match": {
      "ican.subcategory.name": { $in: ["Cricket","Football"] }
    }
  },
  {
    "$project": { "_id": 1, "name": 1, }
  }
])

我得到的是综合结果，我需要个人比赛记录。我尝试了 $all 和 $elementMatch 但得到了相同的响应。我怎样才能得到如下结果。我正在使用 $aggregate 因为我将使用 $geoNear 管道来获取附近的用户。

// current result
[
  {
    "_id": ObjectId("5a934e000102030405000000"),
    "name": "Mr Cool"
  }
]

// expected result
[
  {
    "_id": ObjectId("5a934e000102030405000000"),
    "name": "Mr Cool",
    "subcategory: "Cricket"
  },
  {
    "_id": ObjectId("5a934e000102030405000000"),
    "name": "Mr Cool",
    "subcategory: "Footbal"
  }
]

谢谢

Answer 1

试试这个 Mongo Playground

db.col.aggregate([
    {"$unwind" : "$ican"},
    {"$unwind" : "$ican.subcategory"},
    {"$match" : {"ican.subcategory.name": { "$in": ["Cricket","Football"] }}},
    {"$group" : {"_id" : null,"data" : {"$push" : {"_id" : "$_id","name" : "$name","subcategory" : "$ican.subcategory.name"}}}},
    {"$unwind" : "$data"},
    {"$replaceRoot" : {"newRoot" : "$data"}}
])