select requestid, count(*) as 'nodeNum'from (
select
w.requestmark,
w.requestname,
w.requestid,
(select lastname from hrmresource where id =c.userid) as lastname,
(select nodename from workflow_nodebase where id=c.nodeid) as nodename,
c.isremark,
c.nodeid
from workflow_requestbase w
inner join workflow_currentoperator c
on w.requestid=c.requestid
inner join workflow_nodebase n
on c.nodeid=n.id
where
w.createdate between '2024-01-01' and '2024-12-30'
and w.workflowid=(select workflowid from workflow_requestbase where requestid=588406)
and n.isstart =0 and n.isend =0
) as abc
GROUP BY nodeid,requestid
E9-查询流程经过哪些节点
于 2024-07-15 14:22:50 首次发布