直接访问K2数据库找未归档正在进行中的流程的SQL语句

 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'