SELECT * FROM [订单] where 1=1 ${if(len(AK)>0," and 订单id in ('" +replace(AK, "\n","','")+ "')","")}
目前这个SQL已经能够实现精确查询,模糊查询该怎么改?
${if(len(AK)>0," and (订单id like '%" +replace(AK, "\n","%' or 订单id like '%")+ "%' )","")}
模糊查询用 like
下拉复选框多值模糊查询- FineReport帮助文档 - 全面的报表使用教程和学习资料 (fanruan.com)
模糊查询一般都是输入框控件,你in的话应该是多选框,多选的话会查不出来值的