|
最佳回答 |
|
1
|
y715Lv7见习互助发布于2024-7-10 14:43（编辑于 2024-7-10 14:49）
|
${switch(Type,"已点检","对应已点检的语句","应点检","对应应点检语句","未点检","对应未点检语句")} |
|
|
|
|
最佳回答 |
|
1
|
Z4u3z1Lv6专家互助发布于2024-7-10 14:40（编辑于 2024-7-10 14:45）
|
${if(条件1,"sql1"."sql2"} ----------- ${if(Type == "已点检","应点检的语句 WHERE 已点检的条件语句","应点检的语句 WHERE 未点检的条件语句")} ----- 不过我们通常这样写 应点检的语句 WHERE 1=1 ${IF(Type == "已点检"," AND 已点检的条件",," AND 未点检的条件")} |
|
|
|
|
最佳回答 |
|
1
|
snrtuemcLv8专家互助发布于2024-7-10 14:40
|
${if(参数="1","sql1",if(参数="2","sql2","sql3"))} 这个格式 |
|
|
|
|
最佳回答 |
|
0
|
SSVIPLv4见习互助发布于2024-7-10 14:50
|
我发现直接写两个条件判断也可以实现 ${if(Type == "已点检","已点检的条件语句","应点检的语句")} ${if(Type == "未点检","未点检的条件语句","应点检的语句")} |
|
|
|
1min目标场景问卷
立即参与
