select
from table_name
where colum1=${参数1}
colim1为int类型 参数1为字符类型
该参数为全局参数
如果是一个字符串 可以用这个
and 1=1 ${if( len(user1) ==0 , "", "and MASS_NO in ('" + ARRAY(replace(user1,",","','")) + "') " )}
参考
---------多选
and 1=1 ${if(len(p_name) == 0 , "", " and MASS_NO in ('"+p_name+"') " )}
1min目标场景问卷
立即参与
