如何使用aggregrate在mongodb到$match _id (Compass)



我尝试在指南针中做大聚合请求。我需要通过比较ObjectIds来过滤数据

{
  _id: ObjectId("5fcc15d567184993fdfd8a24")
  organizationId: ObjectId("5dc3b48f8f69a100022ab8d8")
  relatedObject: {
    organizationId: ObjectId("5dc3b48f8f69a100022ab8d8")
    ...
  }
}

我需要得到集合在organizationId = relatedoobject .organizationId。简单的

$match {
  organizationId: { $eq: "$order_history_items.organizationId" }
}

不工作,无响应。我想是因为目标比较。我该怎么做没有toHexString()或类似的东西是不可用的指南针?

答案:

{
  $expr: { $eq: ["$organizationId", "$order_history_items.organizationId"]}
}

最新更新