Page tree
Skip to end of metadata
Go to start of metadata
Tüm bağlantılar
select * from 
(
			select  
					distinct
					l.Name as 'Kutuphane',
					p.Name as 'SurecAdi',
					SurecVeri.Ent.value('(./@Function)[1]','nvarchar(max)') as Adı,
					'BAPI' as Tipi
			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('//BAPI') as SurecVeri(Ent)
			UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			WebVeri.Ent.value('(./@Url)[1]','nvarchar(max)') as Adı,
			'WebInvokeNS' as Tipi

			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('//WebInvokeNS') as WebVeri(Ent)
			UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			Web2Veri.Ent.value('(./@Url)[1]','nvarchar(max)') as Adı,
			'WebInvoke' as Tipi

	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('//WebInvoke') as Web2Veri(Ent) 

	UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
			'SqlSelect' as Tipi

	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('//SqlSelect') as Web2Veri(Ent) 
	UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
			'SqlExec' as Tipi

	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('//SqlExec') as Web2Veri(Ent) 
	UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
			'SqlInsert' as Tipi

	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('//SqlInsert') as Web2Veri(Ent) 
	UNION ALL

			select  
			distinct
			l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
			'SqlUpdate' as Tipi

	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('//SqlUpdate') as Web2Veri(Ent) 

) as Temp order by 1,2
  • No labels