where 1=1
${if(len(xzqh)==0,""," AND RIGHT(roadcode,6) LIKE '"+xzqh+"%'")}
${if(len(xzdj)==0,""," AND xzdj LIKE '"+xzdj+"%'")}
${if(len(dj)==0,""," AND dj LIKE '"+dj+"%'")}
三个参数控件用的是同一个数据集做的字典,所以才会出现这种情况;分别用「三个数据集」做字典即可!
————————
-- 补充:
SQL语句实现下拉框参数联动-https://help.fanruan.com/finereport/doc-view-1284.html
——————————