${if(len(XZDJ)==0,""," AND A.行政等级 like in '"+XZDJ+"%'")}
语句改成这样
${if(len(XZDJ)==0,""," AND A.行政等级 in ('"+XZDJ+"')")}
分隔符号设置为 ','
1.${if(参数="","","and 字段名 in('"+replace(参数,",","','")+"')")} 2.按这个这个格式。无论参数是数字。字符串 都不会报错
参考:下拉复选框实现多值查询-https://help.fanruan.com/finereport10.0/doc-view-1024.html
首先
${if(len(XZDJ)==0,""," AND A.行政等级 like in ('"+XZDJ+"')")}
然后分隔符改成
','
---------------