select* from 员工信息表
where 1=1 ${if(len(部门1)==0,"","and 部门 ='"+ 部门1 +"'")}
${if(len(职位1)==0,"","and 职位 ='"+ 职位1 +"'")};
无法实现
${if(len(参数名) == 0,"","and 字段名 in ('" + replace(参数名,",","','") + "')")}
lhttps://help.fanruan.com/finereport10.0/doc-view-4181.html
你这样写
查询数据肯定过滤，你要两个下拉控件联动吧
控件选项联动-https://help.fanruan.com/finereport/doc-view-4474.html
1min目标场景问卷
立即参与
