#4.29 开发问题
#1. 需要关联到另外一张表的字段的合并
解决:查出审核ID和名字合并的字段,并管理审核ID主键
LEFT JOIN (
SELECT
t6.ATTACHCHECK_ID AS “ATTACHCHECK_ID”,
wm_concat (TO_CHAR(t7.PSN_NAME)) AS “PSN_NAME”
// 按审核ID合并人员ID ,因审核ID是主表需要关联的字段。
FROM
T_DUTY_ACT_ATTACHDISTRIBUTE t6
LEFT JOIN T_HR_PERSON_INFO t7 ON t7. ID = t6.PSN_ID
AND t7.del_flag = ‘0’
WHERE
t6.del_flag = ‘0’
GROUP BY
t6.ATTACHCHECK_ID
) u1 ON u1.ATTACHCHECK_ID = A . ID
#2.问题描述:分发对象模糊查询,因分发对象是合并显示的,且主表未存该字段,直接关联会查会多出数据。
解决:
AND a.id in (SELECT
T8.ATTACHCHECK_ID
FROM
T_DUTY_ACT_ATTACHDISTRIBUTE
T8
LEFT JOIN T_HR_PERSON_INFO T9 ON T9. ID = T8.PSN_ID
AND T9.del_flag
= ‘0’
WHERE
T9.PSN_NAME LIKE
‘%’||#{distPsnName}||’%’
‘%’+#{distPsnName}+’%’
concat(’%’,#{distPsnName},’%’)
AND T8.DEL_FLAG = ‘0’)
</if>
模糊查出存人员表的审核Id,再用主表的in查出。