finereport 多条件查询坑爹问题

模糊查询是%的字符串拼接问题 like ‘"’%’+name+’%’"

select * from as_monthlyassessmententity where 1=1
${if(len(year)==0, "", " and year = '"+year+"'")}
${if(len(month)==0,"","and month in("+month+")")}
${if(len(name)== 0,"","and name like '"'%'+name+'%'"'")};