SELECT
a.creater '发起人ID',
c.receivedate + ' ' + c.receivetime '接收时间',
b.nodename '节点名称',
d.lastname '接收人姓名'
FROM
WORKFLOW_REQUESTBASE a
LEFT JOIN workflow_nodebase b ON a.currentnodeid = b.id
LEFT JOIN workflow_currentoperator c ON a.requestid = c.requestid
AND a.currentnodeid = c.nodeid
LEFT JOIN HrmResource d ON c.userid = d.id
WHERE
a.requestid = '909061';--替换为流程requestId
泛微E9 OA 通过requestId获取流程当前待办人
于 2022-01-25 11:18:31 首次发布