填报表事业参数设置：单选下拉，从其他系统传bg参数，控制显示什么，数据集为：with temp_table as (select 'LCD' as bg_nameunion select 'OLED' as bg_nameunion select '核心部品' as bg_nameunion select '终端产品' as bg_name)select bg_namefrom temp_tablewhere 1=1--and bg_name = ${bg}${if(len(bg) == 0,"and 1=0","and bg_name in ("+"'"+replace(bg,',',"','")+"'"+")")}三级科目依据事业筛选框联动，多选下拉，设置的数据集为：select distinct third_sub ,order_numfrom ods_finereport.to_qa_subject_cfgwhere second_sub ='外部损失' and data_source ='手工录入'and is_del = 'N'--${if(len(事业)=0, "" , "and gp_type in ('"+事业+"')")}${if(len(bg) = 0,"and 1=2", "and gp_type in ('"+replace(bg,",","','")+"')")}${if(len(事业) = 0,"", "and gp_type ='"+事业+"'")}order by order_num四级科目根据三级科目以及事业筛选联动，设置的数据集为：select distinct forth_sub ,third_sub ,order_numfrom ods_finereport.to_qa_subject_cfgwhere second_sub ='外部损失' and data_source ='手工录入'and is_del = 'N'${if(len(三级科目)=0, "" , "and third_sub in ('"+三级科目+"')")}${if(len(bg) = 0,"and 1=2", "and gp_type in ('"+replace(bg,",","','")+"')")}${if(len(事业) = 0,"", "and gp_type ='"+事业+"'")}order by order_num但是选中四级科目，会清空三级科目的筛选，但是对事业筛选不会造成影响
