where 1=1 ${if(len(start_date)=0 && len(end_date)=0,""," and TO_CHAR(O.Requestedshipdate + '8 / 24', 'yyyy-mm-dd hh24:mi')")} and TO_CHAR(O.Requestedshipdate + '8 / 24', 'yyyy-mm-dd hh24:mi') >= '${start_date}' 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+"')")} |