ds1: select id from fine_user where userName='${fine_username}' ds2: select id,rootId from (select id from fine_department where name='${indexofarray(reversearray(split(getuserdepartments(),",")),1)}') as a join (select id as rootId from fine_department where name='${indexofarray(split(getuserdepartments(),","),1)}') as b on 1=1 =============================================================== 在模板参数中用SQL函数也无法获取数据。 设置模板参数“userId”初始值为 sql("HSQL","select '$fine_username' from fine_user",1,1) 报表中取模板参数“$userId”值返回“$fine_username”,应该是生成模板参数时变量“$fine_username”还未初始化。 |