为啥这个参数不生效啊？

FineReport HmjijsbZ 发布于 2024-3-11 11:15

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

snrtuemcLv8专家互助
发布于2024-3-11 11:16（编辑于 2024-3-11 11:24）

这个引号是中文状态下，改成英文状态的，然后${}中你的拼接也有问题

建议拷贝语句贴出来，给你修改

======

select budget_date,department_name,a.subject_name_2 as subject_name from "L2"."subject_budget_marketing_rd_detail_new" a

where department_type='rd'

and budget_type='存里'

${if(find('财务部',GETUSERDEPARTMENTS())>0&& Fine_role="预算管控", "and department_name in ('"+GETUSERDEPARTMENTS()+"')","")}

group by budget_date,department_name,subject_name_2,subject_no

order by budget_date asc,department_name asc,subject_name_2 asc

举报收起评论(3)

HmjijsbZ(提问者) select budget_date,department_name,a.subject_name_2 as subject_name from \"L2\".\"subject_budget_marketing_rd_detail_new\" a where department_type=\'rd\' and budget_type=\'存里\' ${if(GETUSERDEPARTMENTS() not like \"%财务部%\"&& Fine_role=\"预算管控\", \"and department_name in (\'\"+GETUSERDEPARTMENTS()+\"\')\",\"\")} group by budget_date,department_name,subject_name_2,subject_no order by budget_date asc,department_name asc,subject_name_2 asc

2024-03-11 11:21