现在写了个参数${if(len(company)=0,"","and ttt.company_name in ('"+SUBSTITUTE(company,",","','")+"')")}
想要对应的这个company_name字段里有空值,想要参数不筛选的时候也能匹配上这些空值怎么实现
${if(len(company)=0,"and (ttt.company_name is null or ttt.company_name='')","and ttt.company_name in ('"+SUBSTITUTE(company,",","','")+"')")}
你这个公式就可以啊,这个参数不选,就不做任何执行,就不会过滤啊,你不筛选的时候是全选么,还是都不勾选啊