云开发数据库联表查询无权限
发布于 6 年前 作者 yanghan 13951 次浏览 来自 问答 


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 回复


























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







































哭死







































联表查询不支持小程序端


https://developers.weixin.qq.com/miniprogram/dev/wxcloud/guide/database/join.html

































回到顶部