直接sql中
where 1=1
${if(下拉树控件名="未发布","and (字段A='1' or 字段B='2' )"," and 1=2")}
===================
自己按下面格式,继续拼接
where 1=1
${switch(下拉树控件名,"未发布","and (字段A='1' or 字段B='2' )","已发布","and (字段A='3' or 字段B='4' )","其他","and (字段A='6' or 字段B='7' )")}
============
SELECT * FROM Table1 WHERE 1=1 ${switch(版本状态,"新版"," and is_latest ='1' and acitve_status = 'CONTROL'","旧版"," and acitve_status = 'CURRENT'","新版+当前"," and (is_latest ='1' or acitve_status ='CURRENT')","草稿"," and acitve_status = 'DRAFT'")}