select * from test where 1=1 ${IF(effect_type_data=1,"AND time_dimension=1", IF(effect_type_data=-1 , IF((and( WEEKDAY(start_c) +1=7 , WEEKDAY(end_c) +1=6 )), "AND time_dimension=-1 AND acq_date=DATE_ADD('"+end_c+"',INTERVAL 1 day) " , "AND time_dimension=-1 AND 2=2 AND da.sum_date IS NOT NULL" ) ,"AND time_dimension=-1 AND da.sum_date IS NOT NULL"))} 传入参数 effect_type_data=-1 start_c=‘2023-01-01’end_c=‘2023-01-07 结果是AND time_dimension=-1 AND 2=2 AND da.sum_date IS NOT NULL |
1min目标场景问卷
立即参与
