Page tree
Skip to end of metadata
Go to start of metadata
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)=2018  
Order By 1,2  
  • No labels