Mongodb 怎样对 key 进行模糊查询?

[ptrees]

直接上例子: { "groups": { "a": [ { "id": 1, "status": "open" }, { "id": 2, "status": "open" }, { "id": 3, "status": "closed" } ], "b": [ { "id": 4, "status": "closed" }, { "id": 5, "status": "open" }, { "id": 6, "status": "closed" } ] } }

对这个数据,怎么实现类似 find({"groups.*.status": "closed"}) 这样的查询?

[defunct9]

.filter

[shadow1949]

unwind

[dfourc]

objectToArray
unwind
unwind
性能不好，建议拿数据到代码里操作