已经实现了模糊查询，现在想要在已经选中了一个的情况下，继续模糊查询，多选框
现有已写SQL：
修改之后的SQL：
${if(len(VC) == 0,"","WHERE m.STDPD LIKE '%" + right(VC,INARRAY(split(VC,""),",")-1) + "%' OR m3.MAKTG LIKE '%" + right(VC,INARRAY(split(VC,""),",")-1) + "%'")}
下拉复选框多值模糊查询- FineReport帮助文档 - 全面的报表使用教程和学习资料 (fanruan.com)
你把where 写在外面，if只用来判断
where 1=1
${if(len(VC)==0,"","and (m.STDPD LIKE '%'" + VC + "%' OR m3.MRKTG LIKE '%" + VC + "%' )")}
如果你后面还有VB VD这种，直接加一个if
${if(len(VB)==0,"","and (m.STDPD LIKE '%'" + VC + "%' OR m3.MRKTG LIKE '%" + VC + "%' )")}
1min目标场景问卷
立即参与
