为了账号安全,请及时绑定邮箱和手机立即绑定

Mongodb多层嵌套数组如何更好的查询?

Mongodb多层嵌套数组如何更好的查询?

PHP
开心每一天1111 2019-03-16 13:59:25
现有数据如下 { "_id" : ObjectId("5992c90beeb45634df1c2be4"), "name" : "测试数据1", "status" : { "product" : [ { "id" : ObjectId("59a37f7aef887a1d58b59f4f"), "status" : true }, { "id" : ObjectId("59a37f7bef887a1d58b59f50"), "status" : false }, { "id" : ObjectId("59a3801cef887a1d58b59f55"), "status" : false } ], "line":[] }, "level" : [ { "id" : ObjectId("59a37efeef887a1d58b59f43"), "level" : "A" }, { "id" : ObjectId("59a37f03ef887a1d58b59f44"), "level" : "B" }, { "id" : ObjectId("59a37f03ef887a1d58b59f45"), "level" : "C" } ] }, { "_id" : ObjectId("599e7dc07780bbfa9bee42a9"), "name" : "test数据2", "status" : { "product" : [ { "id" : ObjectId("59a37f7aef887a1d58b59f4f"), "status" : false }, { "id" : ObjectId("59a37f7bef887a1d58b59f50"), "status" : false }, { "id" : ObjectId("59a3801cef887a1d58b59f55"), "status" : false } ] }, "location" : 6, "verify_state" : 0, "level" : [ { "id" : ObjectId("59a37efeef887a1d58b59f43"), "level" : "A" }, { "id" : ObjectId("59a37f03ef887a1d58b59f44"), "level" : "B" }, { "id" : ObjectId("59a37f03ef887a1d58b59f45"), "level" : "C" } ] } ...... 我希望查找出status.product.id包含在 [ObjectId("59a37f7aef887a1d58b59f4f"),ObjectId("59a37f7bef887a1d58b59f50"),ObjectId("59a3801cef887a1d58b59f55")]数组里,同时对应的status.product.status为true的数据,查询语句应该怎么写呢?
查看完整描述

1 回答

  • 1 回答
  • 0 关注
  • 992 浏览

添加回答

举报

0/150
提交
取消
意见反馈 帮助中心 APP下载
官方微信