Page tree
Skip to end of metadata
Go to start of metadata
İş adımları
declare @node nvarchar(100)
set @node='Task'
        l.Name as Kutuphane,
        p.Name as SurecAdi,
        ISNULL(SurecVeri.Ent.value('(./@Type)[1]','nvarchar(max)'),'Step')  as Tipi,
        SurecVeri.Ent.value('(./@Name)[1]','nvarchar(max)') as AdimAdi,
        SurecVeri.Ent.value('(./@Instructions)[1]','nvarchar(max)') as AdimAciklama
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)
  • No labels