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

怼烎@ 2021-09-24 08:14 516阅读 0赞

1、sql

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

2、配置

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70][]

注：[https://bbs.fanruan.com/wenda/question1/69268.html][https_bbs.fanruan.com_wenda_question1_69268.html]

[https://bbs.fanruan.com/wenda/question/15290.html][https_bbs.fanruan.com_wenda_question_15290.html]

[https://bbs.fanruan.com/wenda/question/19372.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

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70]: /images/20210923/5f9fd2dbc944426bb602ef3bc02499e9.png
[https_bbs.fanruan.com_wenda_question1_69268.html]: https://bbs.fanruan.com/wenda/question1/69268.html
[https_bbs.fanruan.com_wenda_question_15290.html]: https://bbs.fanruan.com/wenda/question/15290.html
[https_bbs.fanruan.com_wenda_question_19372.html]: https://bbs.fanruan.com/wenda/question/19372.html