本篇文章介绍泛微E9 OA 通过requestId获取流程当前待办人
requestId获取流程当前待办人SQL语句
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
| SELECT
A.creater AS '创建人Id',
NODE.nodename AS '节点名称',
cr.userId AS '待办人Id',
cr.LASTNAME AS '待办人名称'
FROM
WORKFLOW_REQUESTBASE A
INNER JOIN WORKFLOW_NODEBASE NODE ON NODE.ID = A.CURRENTNODEID
INNER JOIN (
SELECT
REQUESTID,
R1.LASTNAME,
R1.id AS userId,
RECEIVEDATE,
RECEIVETIME
FROM
WORKFLOW_CURRENTOPERATOR C1
INNER JOIN HRMRESOURCE R1 ON R1.ID = C1.USERID
WHERE
C1.ID IN ( SELECT MAX ( ID ) FROM WORKFLOW_CURRENTOPERATOR GROUP BY REQUESTID )
) CR ON CR.REQUESTID = A.REQUESTID
WHERE
A.requestid = '118162';
|