帆软 -sql参数动态拼接 - 例子: 动态表,动态条件
帆软文档链接 : https://help.finereport.com/doc-view-165.htm
SELECT * FROM ${if(table=‘订单’,‘订单’,‘销量’)}
SELECT * FROM 销量 where 1=1 ${if(len(name)==0||len(value)==0,"",“and “+name+”=’”+value+"’")}
帆软文档链接 : https://help.finereport.com/doc-view-165.htm
SELECT * FROM ${if(table=‘订单’,‘订单’,‘销量’)}
SELECT * FROM 销量 where 1=1 ${if(len(name)==0||len(value)==0,"",“and “+name+”=’”+value+"’")}