${if()}里面不能再使用$

$fine_username

这个参数需要登录决策系统才能获取到值

---------------

select org_cd,org_name,org_level,parent_org_cd,parent_org_nm from fin_import.import_financial_budget_org 

where 1=1 

${if(len(sql("中台导数专用MYSQL8"," select  org_code from fin_import.dim_fin_fdp_data_permissions  where  1=1 and lower(user_id)='"+fine_username+"'",1,1))==0,"and org_cd='0'",

" and (org_lv1_cd in (select org_code from fin_import.dim_fin_fdp_data_permissions  where 1=1 and lower(user_id)='"+fine_username+"' ) or org_lv2_cd in (select org_code from fin_import.dim_fin_fdp_data_permissions  where 1=1 and lower(user_id)='"+fine_username+"' ) or org_lv3_cd in (select org_code from fin_import.dim_fin_fdp_data_permissions  where 1=1 and lower(user_id)='"+fine_username+"' ) or org_lv4_cd in (select org_code from fin_import.dim_fin_fdp_data_permissions  where 1=1 and lower(user_id)='"+fine_username+"' ) or org_lv5_cd in (select org_code from fin_import.dim_fin_fdp_data_permissions  where 1=1 and lower(user_id)='"+fine_username+"' ) or org_lv6_cd in (select org_code from fin_import.dim_fin_fdp_data_permissions  where 1=1 and lower(user_id)='"+fine_username+"' ))")}