表格没有设置筛选条件跟FGC_Creator这个有关联，但是页面运行的时候sql会自动带a.`...

select a.`入库日期` as C0,a.`入库单号` as C1,a.`店铺名` as C2,a.`名称集合` as C3,a.`sku集合` as C4,a.`总采购数量` as C5,a.`良品入库数量` as C6,a.`次品入库数量` as C7,a.`配件包装` as C8,a.`入库问题类型ID` as C9,a.`供应商ID` as C10,a.`仓库名称` as C11,a.`采购单号` as C12,(CASE WHEN  1 = 0  THEN a.`打包状态` ELSE NULL END) as C13,(CASE WHEN  1 = 0  THEN a.`打包单号` ELSE NULL END) as C14,(CASE WHEN  1 = 0  THEN a.`打包数量` ELSE NULL END) as C15,(CASE WHEN  1 = 0  THEN a.`海运` ELSE NULL END) as C16,(CASE WHEN  1 = 0  THEN a.`快递` ELSE NULL END) as C17,a.`FGC_Rowversion` as C18,a.`id` as C19 from `erp`.`入库单表` as a  left join `erp`.`用户店铺对照表` as a1 on a.`店铺名` = a1.`授权店铺名` Where a1.`用户名` = @p0 AND (a.`FGC_Creator` = @p0 OR  1 = 0 )  ORDER BY a.`id` DESC limit 30 offset 0

大佬您好，看咱们这个SQL，做了两个表的关联，咱们检查一下咱们这两个数据表中是否有开启行权限，若是有开启行权限的话，表格数据查询行权限也是会生效的，就增加创建者字段条件。


表格没有设置查询条件，这个是网络请求：

您好确实是开了数据权限的

正如楼上版主所述，若是有开启行权限的话，表格数据查询行权限也是会生效的，就会增加创建者字段条件了