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

最新推荐文章于 2024-07-08 16:12:35 发布

l_degege

最新推荐文章于 2024-07-08 16:12:35 发布

阅读量1.3k

点赞数

分类专栏：报表

本文链接：https://blog.csdn.net/l_degege/article/details/106384825

版权

报表专栏收录该内容

13 篇文章 1 订阅

订阅专栏

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