【泛微E9】入职流程开通人员账号后自动更新人员信息卡片中的各级部门
归档——节点前附加操作：编辑DML接口
DML类型：自定义类型
自定义DML语句如下：
UPDATE cus_fielddata c
inner join hrmresource a on a.id = c.id
left join view_bmcjpath v ON a.departmentid = v.id
SET
c.field26 = v.field1,
c.field27 = v.field2,
c.field28 = v.field3,
c.field31 = v.field4,
c.field32 = v.field5,
c.field33 = v.field6
WHERE c.scopeid = -1
and a.workcode = '{?rybh}';