数据集中写sql，ifelse嵌套如何写？忘了怎么写的了

这样一个sql写在模板数据集中该如何写呀，

FineReport wsm123 发布于 2020-6-30 12:05 （编辑于 2020-9-19 17:59）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共2回答

最佳回答

wsm123Lv5初级互助
发布于2020-9-21 10:54

E5XNQ(WJ8%J2NBKWGC3B`67.png

shirokoLv6资深互助
发布于2020-6-30 12:22

用${}调用fr，然后结果用字符串连接

比如

${"select 1 from "+if(条件,"dual","dual where 1=0" )}

举报收起评论(7)

wsm123(提问者) 关键是在isrelation!=1的时候，里面再有判断该怎么写？

2020-06-30 14:01

wsm123(提问者) select t.* from V_MAT_PAYMENT_REQUEST t where order_type =\'32\' ${if(isRelation=\"1\",\" and contract_id=\'\"+contract_id+\"\' \",\" AND CREATE_DATE>=TO_DATE(\'\"+start_date+\"\',\'yyyy/MM/dd\') AND CREATE_DATE < TO_DATE(\'\"+end_date+\"\', \'yyyy/MM/dd\') + 1 AND (select a.info_detail_value1 from equ_sys_info_detail a where a.info_type_code = \'526\' and a.info_detail_code = (SELECT TRUE_FACTORY FROM PERS_BASEINFO WHERE perscode= \'\"+currentEmpCode+\"\')) like \'%\' || FACTORY_CODE || \'%\' and query_column like \'%\' || \'\"+query_column+\"\' || \'%\'\")} ${if(isRelation=\"1\",\"\",if(len(FactoryCode)>0&&FactoryCode!=\"%\",\" AND ( instr(\'\"+FactoryCode+\"\',FACTORY_CODE)>0 )\",\"\"))} ${if(isRelation=\"1\",\"\",if(len(order_state)>0&&order_state!=\"%\",\" AND ( ORDER_STATE =\'\"+order_state+\"\' ) \",\"\"))} ${if(isRelation=\"1\",\"\",if(len(create_emp)>0&&create_emp!=\"%\",\" AND ( CREATE_EMP =\'\"+create_emp+\"\' )\",\"\"))} order by create_date DESC 这样写为什么不对呀？

2020-06-30 14:04