|
最佳回答 |
|
0
|
用户k6280494Lv6资深互助发布于2022-12-8 11:44
|
${if(and(len(FTCWNumS)=0,len(FTCWNumE)=0),"","and FTCWNum>='"+ FTCWNumS +"' and FTCWNum<= '"+ FTCWNumE +"'")} |
|
|
|
|
最佳回答 |
|
0
|
slowtimeLv6见习互助发布于2022-12-8 11:33（编辑于 2022-12-8 11:38）
|
拆分成两个： ${if(len(s_time) == 0,"","and riqi >= '" + s_time + "'")} ${if(len(e_time) == 0,"","and riqi <= '" + e_time + "'")} |
|
|
|
|
最佳回答 |
|
0
|
spring_luvLv4见习互助发布于2022-12-8 11:33（编辑于 2022-12-8 11:34）
|
${if(and(len(FTCWNumS)==0,len(FTCWNumE)==0),""," AND () ")} |
|
|
|
|
最佳回答 |
|
0
|
peng_chLv6初级互助发布于2022-12-8 11:34
|
${if(and(len(aa)==0,len(bb)==0),""," AND 查询条件 ")} | |
|
|
|
|
|
最佳回答 |
|
0
|
NikoLv4见习互助发布于2022-12-8 11:39
|
${if(len(s)==0 && len(e)==0," "," and (sdate >='"+s+"' and edate <='"+e+"' ")} |
|
|
|
|
最佳回答 |
|
0
|
熊猫儿你的邮件Lv3见习互助发布于2022-12-8 13:32
|
${IF(AND(LEN(FTCWNumS)=0,LEN(FTCWNumE)=0),"","AND FTCWNum BETWEEN ('" + FTCWNumS + "') AND ('" + FTCWNumE + "')")}) |
|
|
|
1min目标场景问卷
立即参与
