泛微OA批量修改某个矩阵所在节点的会签属性SQL

/*1、备份workflow_groupdetail*/
create table workflow_groupdetail_20230809 as select *from workflow_groupdetail

/*2、更新节点会签属性为 2依次逐个处理*/

UPDATE workflow_groupdetail
SET signorder = 2
WHERE signorder <> 2 and
    GROUPID IN 
(
SELECT H.GROUPID FROM

/*----查询矩阵所在节点的会签属性*/
(
SELECT t.GROUPID ,g.name  as  矩阵名称,c.DISPLAYNAME as 矩阵字段列名称,f.workflowname as 流程名称,A.nodeid as 节点ID,A.GROUPNAME as 节点名称,
(CASE T.signorder
WHEN '0' THEN '非会签'
WHEN '1' THEN '会签'
WHEN '2' THEN '依次逐个签' END
) AS '审批属性' 
FROM workflow_groupdetail T 
left join workflow_nodegroup A on t.GROUPID = A.ID
left join workflow_groupdetail_matrix  b on b.groupdetailid=t.id
left join matrixfieldinfo c on c.id = b.value_field
left join workflow_nodebase d on d.id=a.nodeid
left join workflow_flownode e on e.nodeid = d.id
left join workflow_base f on f.id = e.workflowid
left join matrixinfo g on g.id = b.matrix
where   f.ISVALID = 1 and c.DISPLAYNAME = '医院信息管理部' 
)H
)