比如:select * from system_user where username like '%外面的查询条件%'
#{jeelowcode_auto_where}这个占位符是,通过前端传过来的动态匹配,
没太明白,比如我下在的一个报表使用自定义sql,如果把条件拼进去,下面这样加直接报错:
select s.*,
k.code sku_code,
k.name sku_name,
k.unit,
k.spec,
k.min_stock,
k.max_stock,
c.name cate_name,
w.name warehouse_name,
u.nickname user_name,
d.name dept_name
from (select sum(num) as num,warehouse_id,sku_id from data_sku_stock t group by warehouse_id,sku_id) s
left join data_sku k on s.sku_id = k.id
left join system_users u on k.user_id = u.id
left join system_dept d on k.dept_id = d.id
left join data_category c on k.cate_id = c.id
left join data_warehouse w on s.warehouse_id=w.id
where (s.num<ifnull(k.min_stock,0) or s.num>ifnull(k.max_stock,10000))
#{jeelowcode_auto_where}
@超级管理员
怎么放查询条件,请提供一个例子
select * from system_user where username like '%外面的查询条件%',外面的查询条件???这什么意思
select * from student where is_delete=0 and #{jeelowcode_auto_where}
#{jeelowcode_auto_where}

这个占位符是,通过前端传过来的动态匹配,