数据集加了
${if(len(object_1) == 0,"","and amount >= '" +object_1 + "'")}
${if(len(object_2) == 0,"","and amount <= '" +object_2 + "'")}
就出不来了 控件名也对着
默认值的问题,默认值为0 没有0的值
select * from 表 where 1=1 ${if(len(object_1) == 0,"","and amount >= '" +object_1 + "'")} ${if(len(object_2) == 0,"","and amount <= '" +object_2 + "'")}
这个格式 的话,sql是没有问题的,检查下那边有没有筛选了