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)=2018  
Order By 1,2  

 

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