回答:where 1=1 ${if(len(start_date)==0," ","and TO_CHAR(O.Requestedshipdate + '8 / 24', 'yyyy-mm-dd hh24:mi') >= '"+start_date+"'")}${if(len(end_date)==0," ","and TO_CHAR(O.Requestedshipdate + '8 / 24', 'yyyy-mm-dd hh24:mi') <= '"+end_date+"'")}${if(len(wbdh)==0,"","and O.EXTERNORDERKEY in('"+wbdh+"')")} ${if(len(wlbm)==0,"","and OD.SKU in('"+wlbm+"')")} ${if(len(scdd)==0,"","and o.notes in('"+scdd+"')")} ${if(len(ckdlx)==0,"","and ot.description in('"+ckdlx+"')")}