|
本帖最后由 One 于 2019-5-9 16:15 编辑
在菜单配置好数据规则-》sql自定义表达式后,给相应的角色授权异常,报sql语句错误
SELECT COUNT(1) FROM ( SELECT id,userid,realname,username,shopname,shopurl,type,account_w,credit,favorable_rate,dsr,address,product_num,sale_month_num,create_shop_time,service_phone,collection_num,analysis_url,monitor_url,status,phonestatus,isconnect,iswechat,tag,sys_org_code,sys_company_code,create_by,create_time,update_by,update_time FROM tzg_customer_reserve
WHERE ( name like '%张%' or age > 10 ) AND ( table_name like '%test%' or is_tree = 'Y' ) AND ( 22 ) AND ( id in (select dataid from tzg_assign_log where username='test1' and modal='CustomerReserveAssign') ) AND sys_company_code = ? AND create_by = ? AND sys_org_code LIKE ? AND username = ? ORDER BY create_time DESC ) TOTAL
at com.alibaba.druid.wall.WallFilter.checkInternal(WallFilter.java:800)
查找错误后看到
|
|