帆软报表
帆软报表JSON处理后,求和:sql语句 IFNULL(REPLACE ( REPLACE( GROUP_CONCAT( t2.other_fee -> '$[*].feeTotal' ) ,"[",'') ,"]", '') , 0) as '分摊纯数字(总计)', -- 例如: 原始数据库数据: [{"feeCode":"10045","feeName":"预估运费","feeTotal":100.0000}],[{"feeCode":"10045","feeName":"预估运费
原创
2021-04-07 16:06:11 ·
695 阅读 ·
0 评论