这个是文档里面的主体 SQL:
SELECT * FROM 订单 where 货主地区 in ('${area}') and 货主省份 in ('${province}') and 货主城市 in ('${city}')
城市选项SQL:
SELECT distinct 货主城市 FROM 订单 where 货主地区 in ('${area}') and 货主省份 in ('${province}')
地区选项SQL;
select distinct 货主地区 from 订单
省份选项SQ:SELECT distinct 货主省份 FROM 订单 where 货主地区 in ('${area}')
SELECT *
FROM 订单
where 1=1
${if(len(area) = 0,"","and 货主地区 in ('"+area+"')")}
${if(len(province) = 0,"","and 货主省份 in ('"+province+"')")}
${if(len(city) = 0,"","and 货主城市 in ('"+city+"')")}
帮助文档搜 下拉复选框参数为空选择全部 看里面就知道了
https://help.finereport.com/doc-view-2395.html 请参考
SELECT * FROM 订单
${if(len(area)=0,"","and 货主地区 in ('"+area+"')")}
${if(len(province)=0,"","and 货主省份 in ('"+province+"')")}
${if(len(city)=0,"","and 货主城市 in ('"+city+"')")}