云开发数据库联表查询无权限

发布于 7 年前作者 yanghan14157 次浏览最后编辑 7 年前来自 ask

const db = wx.cloud.database()
    db.collection('pets')
    .get() 
    .then(res => {
      console.log(res)
      this.setData({
        pets: res.data
      })
    })
const db = wx.cloud.database()
    db.collection('shop')
    .get() 
    .then(res => {
      console.log(res)
      this.setData({
        pets: res.data
      })
    })

正常查询都没问题

const db = wx.cloud.database()
    db.collection('pets').aggregate()
    .lookup({
      from: 'shop',
      localField: 'shopId',
      foreignField: '_id',
      as: 'shop'
    })
    .end() 
    .then(res => {
      console.log(res)
      this.setData({
        pets: res.data
      })
    })
      .catch(err => console.error(err))

联表查询就报没权限了

VM490:1 Error: errCode: -502003 database permission denied | errMsg: Permission denied
    at new u (WAService.js:1)
    at Function.success (WAService.js:1)
    at Object.success (WAService.js:1)
    at r (WAService.js:1)
    at WAService.js:1
    at v (WAService.js:1)
    at WAService.js:1
    at t.<anonymous> (VM504 asdebug.js:1)
    at WAService.js:1
    at WAService.js:1
3 回复
chenli
chenli1 楼6 年前

不支持小程序端,在云函数里使用吧

tzou
tzou2 楼6 年前

哭死