泛微E9 OA 通过requestId获取流程当前待办人

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