javascript - $group 嵌套数组元素

Question

想知道如何使用MongoDB的聚合来汇总每个reason_id的计数:

我想知道“reason_id = KW7Kcsv7835YZeE3n”有 2 个计数，“reason_id = KNcKQCjhFzha3oLfE”有 1 个计数。

这是我的数据:

[
  {
    "_id": "2DLQFJLbZScBXpSam",
    "toilet_id": "bJsyfh3TCvpTzE2mJ",
    "reason_ids": [
      "KNcKQCjhFzha3oLfE",
      "KW7Kcsv7835YZeE3n"
    ],
    "score_id": null,
    "toilet": {
      "_id": "bJsyfh3TCvpTzE2mJ",
      "name": "Toilet_M_1",
      "gender": "m",
      "mac_address": "11:11:11:11:11:11"
    }
  },

  {
    "_id": "akjsbcjascklsacas",
    "toilet_id": "bJsyfh3TCvpTzE2mJ",
    "reason_ids": [
      "KW7Kcsv7835YZeE3n"
    ],
    "score_id": null,
    "toilet": {
      "_id": "fsgndgklndsdsdsd",
      "name": "Toilet_F_1",
      "gender": "f",
      "mac_address": "11:11:11:11:11:11"
    }
  },
]

Answer 1

你可以试试这个

db.collection.aggregate([
  {
    "$unwind": "$reason_ids"
  },
  {
    "$group": {
      "_id": "$reason_ids",
      "count": {
        "$sum": 1
      }
    }
  }
])

输出

[
  {
    "_id": "KW7Kcsv7835YZeE3n",
    "count": 2
  },
  {
    "_id": "KNcKQCjhFzha3oLfE",
    "count": 1
  }
]

试一试 here