目前设置的是单选时候的,现在改为复选控件了,求助
-- 参数控件为空选择全部
SELECT * FROM table_name
WHERE 1 = 1
${if(len(参数1) == 0,"","and 字段1 = '" + 参数1 + "'")} -- 下拉框单选
${if(len(参数2) == 0,"","and 字段2 in ('" + replace(参数2,",","','") + "')")} -- 复选框多选
-- 联动从第一个参数往下结合
${if(len(参数) == 0,""," and 字段 in ( '" + SUBSTITUTE(参数,",","','") + "')")}
===============
记得改一下组件的分隔符
${if(len(xz)=0,""," AND cei1.showvalue IN ('"+JOINARRAY(SPLIT(xz,','),"','")+"')")}