最近在oa项目中使用acitiviti中,遇到一个排他网关有多个判断条件(),并且可以多次执行,在显示已办任务的时候要归属为一条数据,利用GROUP_CONCAT和CONCAT加上group by 解决。
详细sql如下:
SELECT aht.ID_ AS id, ard.NAME_ AS processName, aht.NAME_ AS name , art.NAME_ AS currentName, csp.post_name AS postName, GROUP_CONCAT(CONCAT(ahd.NAME_,':',ahd.TEXT_)) AS message, ahp.END_TIME_ AS endTime FROM act_hi_taskinst aht LEFT JOIN act_re_procdef arp ON aht.PROC_DEF_ID_ = arp.ID_ INNER JOIN act_re_procdef_ext arpe ON arp.ID_ = arpe.act_re_procdef_id LEFT JOIN act_re_deployment ard ON arp.DEPLOYMENT_