Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Aşağıdaki sorguda Mail yazan bölüme istediğiniz bir ITask ismini verdiğinizde sistemde kullanılma sayısına ve örneklerinin xml versiyonlarına ulaşabilirsiniz. 

Code Block
languagesql
titleSql Sorgusu
linenumberstrue
declare @node nvarchar(100)
set @node='Mail'

select 
        l.Name as Kutuphane,
        p.Name as SurecAdi,
        @node  as Tipi,
		SurecVeri.Ent.query('.') as Kullanim
from    wflProcesses p inner  join
        wflLibraries l on l.Id=p.Library inner join
        wflProcessVersions pv on pv.Id=p.CurrentVersion cross apply
		pv.Graph.nodes('//*[local-name()=sql:variable("@node")]') as SurecVeri(Ent)