zoezy
zoezy
  • 发布:2023-10-24 17:49
  • 更新:2023-10-25 11:14
  • 阅读:220

unicloud-db 多表联查,权限报错问题

分类:uniCloud

zy-contacts,basic-data-tag,basic-data-company
主表zy-contacts 的tag关联"foreignKey": "basic-data-tag._id"
这三张表的schema内权限配置都是
"permission": {
"read": "doc.create_by == auth.uid",
"create": "auth.uid !=null",
"update": "doc.create_by == auth.uid",
"delete": "doc.create_by == auth.uid"
},

unicloud-db组件的collection是
[db.collection('zy-contacts').field('avatar_file,username,mobile,greetings,tag,company,duties,remarks,create_by').getTemp(),
db.collection('basic-data-tag').field('_id, name as text').getTemp(),
db.collection('basic-data-company').field('_id, name as text').getTemp()]

列表筛选 where 传参create_by==$cloudEnv_uid && tag == "652ce6f07ad52d7c8a18ee16"
报错内容:PERMISSION_ERROR 权限校验未通过,参与权限校验的集合:[zy-contacts,basic-data-tag,basic-data-company]
把unicloud-db组件的collection改成'zy-contacts',是正常的,为什么联表时会报权限错误

2023-10-24 17:49 负责人:无 分享
已邀请:
DCloud_uniCloud_WYQ

DCloud_uniCloud_WYQ

你的这个where应该放在主表对应的getTemp内

要回复问题请先登录注册