错误提示：Error in results, duplicate field name `createdById`

中文讨论区 缺陷反馈
1

描述问题

在前端设置了数据范围，如果同时在角色和权限里面设置了数据范围为“自己的数据”。
就会出现报错。
重复字段 ：第二个 created_by_id AS createdById

image
image820×1708 144 KB

image
image1852×584 49.3 KB

image
image1640×654 58 KB

运行环境

  • NocoBase 版本:v1.6.14
  • 部署方式:Docker
  • Docker 镜像版本:v1.6.14
2

完整的错误提示：
Error in results, duplicate field name createdById. (see option checkDuplicate) sql: SELECT t_qyre87ol441.created_at AS createdAt, t_qyre87ol441.created_by_id AS createdById, t_qyre87ol441.f_18rysirld0e, t_qyre87ol441.f_a40yvw1unea, t_qyre87ol441.f_e3hnuwd8v5e, t_qyre87ol441.f_v49d7hyttom, t_qyre87ol441.f_x0f7f5qo1qm, t_qyre87ol441.id, t_qyre87ol441.updated_at AS updatedAt, t_qyre87ol441.updated_by_id AS updatedById, t_qyre87ol441.created_by_id AS createdById FROM t_qyre87ol441 AS t_qyre87ol441 LEFT OUTER JOIN users AS createdBy ON t_qyre87ol441.created_by_id = createdBy.id WHERE ((createdBy.f_1ed16nwt2qo = ‘张三’) AND t_qyre87ol441.created_by_id = 10) ORDER BY ISNULL(t_qyre87ol441.id), t_qyre87ol441.id ASC; - parameters:

4

我也遇上这个问题了，但是日历区块里没有添加筛选

5

请问可以按照缺陷反馈模板提供必要的信息吗？ 或者在这个demo里面复现下
https://a_j89r6gwvkw4.v7.demo-cn.nocobase.com/admin/5ve30131jqw

6

@hongboji 请问这个demo的账号密码是？

7

默认的