通过流程ID获取流程当前待办人
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 = '1001';--替换为流程requestId