云开发数据库条件查询数组?

发布于 7 年前作者 leiyi9655 次浏览最后编辑 7 年前来自 ask
{
  s_id:"001",
  goods:[
    {type:"01",name:"aaa",price:10},
    {type:"02",name:"bbb",price:15}
  ]
},
{
  s_id:"002",
  goods:[
    {type:"01",name:"ccc",price:10},
    {type:"02",name:"ddd",price:15}
  ]
}

db.collection("goods").where(_.and([{
     s_id: _this.data.s_id
        }, {
            goods: _.elemMatch({
                type: _this.data.value
            })
        }])).get({
            success: (res => {
                return res
            })
        })
上面两条数据是我goods集合里的两条数据,我就想查s_id等于某个值里面的goods数组条件满足type等于某个值的结果,这样写貌似不行
1 回复
yefang
yefang1 楼4 年前

试试:

.aggregate()

.unwind(‘goods’)

.match({…})