怎么才能，我选择了产品编号后，再选其他的筛选时，前面的筛选仍然存在 ${IF(len(开始时间) == 0,"","and to_char(ENDTIME,'yyyy/MM/dd HH:mm:ss')>='" + 开始时间 + "'")} ${IF(len(结束时间) == 0,"","and to_char(ENDTIME,'yyyy/MM/dd HH:mm:ss')<='" + 结束时间 + "'")} ${if(len(设备编号)==0,'',"and EQUIPMENTNO IN ('"+设备编号+"')")}${if(len(产品编号)==0,'',"and PRODUCTNO IN ('"+产品编号+"')")}${if(len(工单编号)==0,'',"and MONO IN ('"+工单编号+"')")}${if(len(工序1)==0,'',"and 工序 IN ('"+工序1+"')")}${if(len(日期)==0,'',"and DAY IN ('"+日期+"')")} |
1min目标场景问卷
立即参与
