ZT和EDATE是通过超链接跳转过来的,我想实现通过ZT判断然后再使用不同的字段,下面写错了有大佬教教该怎么写吗 WHERE taah.STATUS = '${ZT}' and taah.PRODUCTION_LINE_ID = '${CJBM}' and taalc.ANOMALY_LARGE_NAME = '${YCDL}' ${IF('${ZT}'=='RESPONSE',"","and t.STARTING_DATE <= TO_DATE("+ '${EDATE}' +", 'SYYYY-MM-DD') ")} ${IF('${ZT}'=='HANDLE',"","and t.HANDLE_DATE <= TO_DATE('"+ '${EDATE}' +"', 'SYYYY-MM-DD') ")} ${IF('${ZT}'=='FINISH',"","and t.COMPLETE_DATE <= TO_DATE('"+ '${EDATE}' +"', 'SYYYY-MM-DD') ")} ${IF('${ZT}'=='CLOSE',"","and t.CLOSE_DATE <= TO_DATE('"+ '${EDATE}' +"', 'SYYYY-MM-DD') ")} |