报表下拉框多选查询及一般在sql中添加查询条件

1、sql

SELECT * FROM [销量] 
where 
1=1 ${if(len(销售员1) == 2,"","and 销售员 in (" + 销售员1 + ")")}

2、配置

注：https://bbs.fanruan.com/wenda/question1/69268.html

       https://bbs.fanruan.com/wenda/question/15290.html

       https://bbs.fanruan.com/wenda/question/19372.html

3、在sql中添加查询条件

${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