BPM0942052043: 如果存在协办,加签或者驳回时存在多个实际操作者,这样只能取最大完成时间。
SELECT OT_User.ObjectID,OT_User.Name
FROM OT_WorkItem w
LEFT OUTER JOIN OT_User ON ISNULL(w.Finis...(2017-04-13 09:50)
t156965365: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
...(2017-03-28 10:52)