${IF(LEN(NAME)=0,"","AND B.DESCRIPTION IN ('"+NAME+"')")}
例如上边这个条件(正常情况下),我在AND后边跟字段名,现改成使用字段名的别名的
${IF(LEN(NAME)=0,"","AND B.CPDESCRIPTION IN ('"+NAME+"')")}
这样的方式可以正常实现吗
在外套一层SQL
--------------
eg
SELECT * FROM
(
SELECT 字段A [A],字段B [B] FROM TABLEA ) T WHERE 1=1 ${IF(LEN(控件名)==0,""," AND T.A='"+控件名+"'")}
可以