vectory(提问者) 但是为什么数据集查询两天数据不会报错

回复

2022-08-22 10:46 

取消 回复

vectory(提问者) sql贴不了，有保密协议

回复

2022-08-22 10:53 

取消 回复

Z4u3z1 回复 vectory(提问者) 那只有你自己排除问题，没法未卜先知...

回复

2022-08-22 10:55 

取消 回复

vectory(提问者) 回复 Z4u3z1 where 1=1 ${IF(len(TRIM(brand))==0,\"\",\" AND T1.PRODUCT_BRAND_CODE in (\'\"+TRIM(brand)+\"\') \")} ${IF(len(TRIM(probcate_id))==0,\"\",\" AND T1.PRODUCT_CATEGORY_BIG_CODE in (\'\"+TRIM(probcate_id)+\"\') \")} ${IF(len(TRIM(org_name))==0,\"\",\" AND t1.org_code in (\'\"+TRIM(org_name)+\"\') \")} ${IF(len(TRIM(SERVICE_METHOD_NAME))==0,\"\",\" and SERVICE_METHOD_NAME in (\'\"+TRIM(SERVICE_METHOD_NAME)+\"\') \")} ${IF(len(TRIM(CHANNEL_NAME))==0,\"\",\" and CHANNEL_NAME in (\'\"+TRIM(CHANNEL_NAME)+\"\') \")} and to_char(T1.FINISH_TIME,\'yyyy-mm-dd\') between \'${startDate}\'and \'${endDate}\'

回复

2022-08-22 11:10 

取消 回复

vectory(提问者) 回复 Z4u3z1 sql应该没问题，因为我去掉 参数，数据库里是能正常执行的

回复

2022-08-22 11:11 

取消 回复

还有1条评论 点击查看

评论

vectory(提问者) 不会，这都是对工单号进行count,count出来的值不可能是非数字类型

回复

2022-08-22 10:53 

取消 回复

花无缺爱吃鱼 回复 vectory(提问者) 过滤条件里有没有不规范值

回复

2022-08-22 11:00 

取消 回复

vectory(提问者) 回复 花无缺爱吃鱼 where 1=1 ${IF(len(TRIM(brand))==0,\"\",\" AND T1.PRODUCT_BRAND_CODE in (\'\"+TRIM(brand)+\"\') \")} ${IF(len(TRIM(probcate_id))==0,\"\",\" AND T1.PRODUCT_CATEGORY_BIG_CODE in (\'\"+TRIM(probcate_id)+\"\') \")} ${IF(len(TRIM(org_name))==0,\"\",\" AND t1.org_code in (\'\"+TRIM(org_name)+\"\') \")} ${IF(len(TRIM(SERVICE_METHOD_NAME))==0,\"\",\" and SERVICE_METHOD_NAME in (\'\"+TRIM(SERVICE_METHOD_NAME)+\"\') \")} ${IF(len(TRIM(CHANNEL_NAME))==0,\"\",\" and CHANNEL_NAME in (\'\"+TRIM(CHANNEL_NAME)+\"\') \")} and to_char(T1.FINISH_TIME,\'yyyy-mm-dd\') between \'${startDate}\'and \'${endDate}\'

回复

2022-08-22 11:10 

取消 回复