我的流程中进行中流程不能显示当前审批节点及审批人，如何配置显示？

9.2.7 我的流程中进行中流程不能显示当前审批节点及审批人，如何配置显示？

图片：审批人.png

下面的版本这么有显示当前审批节点及审批人

图片：审批人2.png

这个应该是封装起来的。你可以自己做查询列表。
先使用SQL:
SELECT OT_InstanceContext.*, OT_WorkflowClause.WorkflowName AS WorkflowName, '' AS ApproverLink, '' AS Approver, '' AS ApproverOuDept FROM OT_InstanceContext LEFT JOIN OT_WorkflowClause ON OT_InstanceContext.WorkflowCode=OT_WorkflowClause.WorkflowCode WHERE Originator='18f923a7-5a5e-426d-94ae-a55ad1a4b239' AND OT_InstanceContext.State!=4 AND OT_InstanceContext.State!=5 AND InstanceName LIKE '%%'
搜索出当前账号的流程ObjectID。
然后使用SQL:

SELECT OT_WorkItem.*, OT_InstanceContext.InstanceName AS InstanceName, OT_User.Name AS OriginatorName, OT_InstanceContext.OrgUnit AS OrgUnit
FROM OT_WorkItem
LEFT JOIN OT_InstanceContext ON OT_WorkItem.InstanceId=OT_InstanceContext.ObjectID
LEFT JOIN dbo.OT_User ON OT_User.ObjectID = OT_InstanceContext.Originator
WHERE OT_WorkItem.State<2 AND OT_WorkItem.ItemType<=2 AND OT_WorkItem.InstanceId  IN ('搜索出来的ObjectID')
ORDER BY ReceiveTime DESC


ParticipantName就是处理人ObjectID
ActivityDisplayName就是节点名