报表下拉框多选查询及⼀般在sql中添加查询条件1、sql
SELECT * FROM [销量]
where
1=1 ${if(len(销售员1) == 2,"","and 销售员 in (" + 销售员1 + ")")}
2、配置
注：
3、在sql中添加查询条件sql中select是什么意思
${if(len(qy)==0,""," and qy ='"+qy+"'")}
4、year下拉数据
select 2019 year
union all
select 2020 year
union all
select 2021 year
union all
select 2022 year
union all
select 2023 year
union all
select 2024 year
union all
select 2025 year
union all
select 2026 year
union all
select 2027 year
union all
select 2028 year
union all
select 2029 year
注：如果是oracle，加 from dual。（下同）5、month下拉数据
SELECT 1  id, 1 month
union all
SELECT 2  id, 2 month
union all
SELECT 3  id, 3 month
union all
SELECT 4  id, 4 month
union all
SELECT 5  id, 5 month
union all
SELECT 6  id, 6 month
union all
SELECT 7  id, 7 month
union all
SELECT 8  id, 8 month
union all
SELECT 9  id, 9 month
union all
SELECT 10  id, 10 month
union all
SELECT 11  id, 11 month
union all
SELECT 12  id, 12 month

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。