在MongoDB中嵌套$ addFields [英] Nested $addFields in MongoDB

问题描述

我有以下文档：

[
  {
    "callId": "17dac51e-125e-499e-9064-f20bd3b1a9d8",
    "caller": {
      "firstName": "Test",
      "lastName": "Testing",
      "phoneNumber": "1231231234"
    },
    "inquiries": [
      {
        "inquiryId": "b0d14381-ce75-49aa-a66a-c36ae20b72a8",
        "routeHistory": [
          {
            "assignedUserId": "cfa0ffe9-c77d-4eec-87d7-4430f7772e81",
            "routeDate": "2020-01-01T06:00:00.000Z",
            "status": "routed"
          },
          {
            "assignedUserId": "cfa0ffe9-c77d-4eec-87d7-4430f7772e81",
            "routeDate": "2020-01-03T06:00:00.000Z",
            "status": "routed"
          }
        ]
      },
      {
        "inquiryId": "9d743be9-7613-46d7-8f9b-a04b4b899b56",
        "routeHistory": [
          {
            "assignedUserId": "cfa0ffe9-c77d-4eec-87d7-4430f7772e81",
            "routeDate": "2020-01-01T06:00:00.000Z",
            "status": "ended"
          },
          {
            "assignedUserId": "cfa0ffe9-c77d-4eec-87d7-4430f7772e81",
            "routeDate": "2020-01-03T06:00:00.000Z",
            "status": "ended"
          }
        ]
      }
    ]
  }
]

我正在使用以下总计：

{
  $unwind: '$inquiries',
},
{
  $addFields: {
    'inquiries.routeHistory': {
      $filter: {
        input: '$inquiries.routeHistory',
        cond: {
          $eq: [{ $max: '$inquiries.routeHistory.routeDate' }, '$$this.routeDate'],
        },
      },
    },
  },
},
{
  $group: {
    _id: '$_id',
    callId: { $first: '$callId' },
    caller: { $first: '$caller' },
    inquiries: { $push: '$inquiries' },
  },
}

I想要扩展此查询以便能够进一步对查询粒度进行过滤，以便我只返回包含我指定条件的查询。例如。如果我想找到 inquiry.routeHistory.status =结束的地方，我希望得到以下结果：

I would like to expand this query to be able to further filter at the inquiry grain, so that I am returning only the inquiry that contains my specified criteria. E.g. if I wanted to find where inquiry.routeHistory.status = ended, I would expect the following results:

[
  {
    "callId": "17dac51e-125e-499e-9064-f20bd3b1a9d8",
    "caller": {
      "firstName": "Test",
      "lastName": "Testing",
      "phoneNumber": "1231231234"
    },
    "inquiries": [
      {
        "inquiryId": "9d743be9-7613-46d7-8f9b-a04b4b899b56",
        "routeHistory": [
          {
            "assignedUserId": "cfa0ffe9-c77d-4eec-87d7-4430f7772e81",
            "routeDate": "2020-01-03T06:00:00.000Z",
            "status": "ended"
          }
        ]
      }
    ]
  }
]

有没有一种方法可以嵌套 $ addField 还是我可以走另一条路线？

Is there a way to do nested $addField or is there another route I could take?

推荐答案

自您正在使用 $ unwind ，可以通过添加 $ match 自表达式： inquiries.routeHistory.status：已结束 如果存在任何，将返回 true 文档在 routeHistory 中，其状态为：

Since you're using $unwind you can do that easily by adding $match since expression: "inquiries.routeHistory.status": "ended" will return true if there's any document in routeHistory having such status:

db.collection.aggregate([
    {
        $unwind: "$inquiries"
    },
    {
        $match: {
            "inquiries.routeHistory.status": "ended"
        }
    },
    {
        $addFields: {
            "inquiries.routeHistory": {
                $filter: {
                    input: "$inquiries.routeHistory",
                    cond: {
                        $eq: [ { $max: "$inquiries.routeHistory.routeDate" }, "$$this.routeDate" ]
                    }
                }
            }
        }
    },
    {
        $group: {
            _id: "$_id",
            callId: { $first: "$callId" },
            caller: { $first: "$caller" },
            inquiries: { $push: "$inquiries" }
        }
    }
])

蒙戈游乐场

这篇关于在MongoDB中嵌套$ addFields的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！