阅读:3141
回复:5
|
[已解决]在流程中,多人维护时,如何确定最终是哪个人维护的?图片:捕获1111.JPG 报价单维护可以多人维护,只有一个人维护了就到下个节点(采购经理审批),如何在采购经理审批节点根据上一节点具体的维护人为条件选择参与者? |
2楼#
发布于:2017-04-13 09:50
t156965365:SELECT OT_User.ObjectID,OT_User.Name FROM OT_WorkItem w如果存在协办,加签或者驳回时存在多个实际操作者,这样只能取最大完成时间。 SELECT OT_User.ObjectID,OT_User.Name FROM OT_WorkItem w LEFT OUTER JOIN OT_User ON ISNULL(w.Finisher,w.Participant) = OT_User.ObjectID WHERE w.BizObjectId = '38a9cbab-cd7f-4e44-ac3e-2bebb764ddaa' AND w.State = 2 and w.ActivityCode = 'Activity2' and w.Approval = 1 AND CONVERT(CHAR(23),W.FinishTime, 25) = (SELECT MAX(CONVERT(CHAR(23),W1.FinishTime, 25)) FROM OT_WorkItem w1 WHERE w1.Approval = 1 AND w1.State = 2 and w1.ActivityCode = 'Activity2' and w1.Approval = 1 AND w.BizObjectId = w1.BizObjectId) |
|