我尝试在指南针中做大聚合请求。我需要通过比较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"]}
}