1、时间范围筛选

• {if(len(开始时间)== 0,""," and a.FilingTime>=date_format('"+开始时间+"', '%Y-%m-%d')")} {if(len(结束时间)== 0,""," and a.FilingTime <date_format('"+结束时间+"', '%Y-%m-%d')")}

2、文本框或单选下拉框模糊匹配

• ${if(len(部门)== 0,""," AND REGEXP_LIKE(a.BusinessUnit,TRIM( '"+部门+"'),'i')")}

3、文本框全匹配

• ${if(len(事业部)== 0,""," AND a.BusinessUnit = TRIM( '"+事业部+"')")}

4、复选框模糊匹配

${if(len(专案)== 0,"","AND a.Project in ( '"+专案+"')")}

注意事项：复选下拉框或者单选下拉框需要单独建下拉字典数据集，且该数据集不能有数据集参数