公式能否将SQL函数查出的B010,B011这样的数据显示成B010','B011呢?不一定只有这两个,可能是多个不固定的,SPLIT函数可以分开,但是再怎么拼接呢?
数据库是MYSQL,或者在SQL里实现也可以,SQL试过GROUP_CONCAT,不太行
公式举例:
SQL("FRDemo","SELECT 'B010' AS ID union all SELECT 'B011' AS ID",1)
现在效果
想要实现
JOINARRAY(SQL("FRDemo","SELECT 'B010' AS ID union all SELECT 'B011' AS ID",1),"','")
https://help.fanruan.com/finereport/doc-view-4244.html --SQL中用SQL函数
split(SQL("FRDemo","SELECT 'B010' AS ID union all SELECT 'B011' AS ID",1),"','")