用户72aCb2774(提问者)select
indicator_type as 指标类型,
primary_domain_type as 一级领域类型,
secondary_domain_type as 二级领域类型,
tertiary_domain_type as 三级领域类型,
proportion as 占比,
round(completion_value) as 合同额,
concat(round(year_on_year),\'%\') as 同比,
sys_user as 用户,
sys_time as 时间
from -- TB_ZHHJ_HT
domain_performance_metrics
where
secondary_domain_type<>\'-\'
and
1=1 ${if(len(aaa) == 0,\"\",\"and primary_domain_type = \'\" + aaa + \"\'\")}
${if(len(bbb) == 0,\"\",\"and indicator_type = \'\" + bbb + \"\'\")}