View Code 
1 use k2server
2
3 select
4 b.id, a.procinstid, a.aiexpectedDuration as expectedDuration ,a.ActInstDestID,a.actid,a.EventID,a.ActInstID,convert(varchar,a.ProcInstID)+'_'+convert(varchar,a.ActInstDestID) as sn,b.status,a.aistartdate as startdate
5 ,Destination = (case when c.Destination is null then (select d.ActionerName from K2Server.dbo._Actioners as d (nolock) where d.id = b.actionerid) else c.Destination end)
6 from K2Server.dbo._WorklistHeader as a (nolock)
7 inner join K2Server.dbo._WorklistSlot as b (nolock) on a.id=b.headerid and a.procinstid=b.procinstid
8 left join K2ServerLog.dbo._Worklist as c (nolock) on c.ProcInstID=a.procinstid and c.ActInstDestID=a.ActInstDestID
9 where b.status<>4
10 and a.ProcInstID='4138'
2
3 select
4 b.id, a.procinstid, a.aiexpectedDuration as expectedDuration ,a.ActInstDestID,a.actid,a.EventID,a.ActInstID,convert(varchar,a.ProcInstID)+'_'+convert(varchar,a.ActInstDestID) as sn,b.status,a.aistartdate as startdate
5 ,Destination = (case when c.Destination is null then (select d.ActionerName from K2Server.dbo._Actioners as d (nolock) where d.id = b.actionerid) else c.Destination end)
6 from K2Server.dbo._WorklistHeader as a (nolock)
7 inner join K2Server.dbo._WorklistSlot as b (nolock) on a.id=b.headerid and a.procinstid=b.procinstid
8 left join K2ServerLog.dbo._Worklist as c (nolock) on c.ProcInstID=a.procinstid and c.ActInstDestID=a.ActInstDestID
9 where b.status<>4
10 and a.ProcInstID='4138'
