Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Code Block
languagesql
linenumberstrue
select distinct l.name as Kutuphane,p.Name as SurecIsmi,
       (case when pv.Version='1.0.0' then 'Yeni' else 'Guncelleme' end) as Durum 
from   wflLibraries l left outer join
       wflProcesses p on p.Library= l.Id left outer join
       wflProcessVersions pv on pv.Process=p.Id
where DATEPART(YEAR,pv.CreateDate)=DATEPART(YEAR,dateadd(Year,-1,Getdate()))
Order By 1,2  
Code Block
languagesql
linenumberstrue
select distinct CompletedBy as Sayi from wflWorkItems 
where DATEPART(YEAR,EndDate)=2019