帆软用户y1US11MQDz(提问者)参数没问题,数据集里都写了
SELEct * from mi_probe
where 1=1
and probe_type = '氙灯'
${if(len(dtdStartDate)=0,''," and date_time >=to_date('"+dtdStartDate+"','yyyy-mm-dd')")}
${if(len(dtdEndDate)=0,''," and date_time <=to_date('"+dtdEndDate+"','yyyy-mm-dd')")}
${if(len(cmcFactory)=0,''," and factory_name in ('"+cmcFactory+"')")}
ORDER BY factory_name,probe_type,line_name ,date_time desc