单独写一个数据集,然后在数据集中使用参数$
例一:
共有两个筛选框,第一个筛选框是年份,第二个筛选框是年份后面所跟随的月份
要求:如果每个年份后面所跟随的月份不一样的话,那么就使用
${if(year = '2020',"","/*")}
……
${if(year = '2020',"","*/")}
如:前一个筛选框有两个年份,2020和2021可以选择,那么后一个筛选框就是选择年份里面的月份
20年里面有两个月份可以选择,21年里面有三个月份可以选择
${if(year = '2020',"","/*")}
SELECT * FROM (
SELECT '一月份' AS MONTH FROM DUAL
UNION
SELECT '二月份' AS MONTH FROM DUAL
) A
ORDER BY MONTH DESC
${if(year = '2020',"","*/")}
${if(year = '2021',"","/*")}
SELECT * FROM (
SELECT '三月份' AS MONTH FROM DUAL
UNION
SELECT '四月份' AS MONTH FROM DUAL
UNION
SELECT '五月份' AS MONTH FROM DUAL
) A
ORDER BY MONTH DESC
${if(year = '2021',"","*/")}
例二:
可延展到数据库表中的选项
前一个筛选框选择年龄,后一个筛选框选择人名
如表中年龄等于12岁,13岁的人的姓名,
${if(age = '12',"","/*")}
select distinct
name AS NAME01
from emp
${if(year = '12',"","*/")}
${if(age = '13',"","/*")}
select distinct
name AS NAME01
from emp
${if(year = '13',"","*/")}