liuyan123(提问者) where 1=1
${if(len(unit) == 0,"","and response_unit in ('"+unit+"')")}
${if(len(year_assess) == 0,"","and 'if_yearCheck' in ('"+year_assess+"')")}
and year ='${year}' 这样写还是不对啊

回复

2025-04-23 13:01 

取消 回复

liuyan123(提问者) 去掉会报错，说这列不存在，而且在select中查询该值要加双引号才能正常查询。

回复

2025-04-23 13:09 

取消 回复

snrtuemc 回复 liuyan123(提问者) 那就换成这样
${if(len(year_assess) == 0,"","and \"if_yearCheck\" in ('"+year_assess+"')")}

回复

2025-04-23 13:13 

取消 回复

liuyan123(提问者) 回复 snrtuemc 已解决，谢谢！

回复

2025-04-23 13:22 

取消 回复