Versions Compared

Old Version 5

changes.mady.by.user R.Ebiflow

Saved on

compared with

New Version Current

changes.mady.by.user ss.ebiflow

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Code Block
languagesql
titleTüm bağlantılar
linenumberstrue
select * from 
(
			select  
					        distinct
					        l.Name as 'Kutuphane',
					        p.Name as 'SurecAdi',
					        SurecVeri.Ent.value('(./@Function)[1]','nvarchar(max)') as Adı,
					'BAPI' as        '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
			 
            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
				  '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
			          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         wflProcessVersions pv on pv.Id=p.CurrentVersion cross apply
			            pv.Graph.nodes('//WebInvoke') as Web2Veri(Ent)
    

	 UNION ALL 

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

	from       wflProcesses p inner  join
			 'JsonInvoke' 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            pv.Graph.nodes('//SqlSelectJsonInvoke') as Web2Veri(Ent)
    
	 UNION ALL 


			select  
			distinct
			
            distinct
            l.Name as 'Kutuphane',
			            p.Name as 'SurecAdi',
			            Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
			'SqlExec            '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('//SqlExecSqlSelect') as Web2Veri(Ent)
    
	 UNION ALL 

			select  
			distinct
			
            distinct
            l.Name as 'Kutuphane',
			            p.Name as 'SurecAdi',
			            Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
			'SqlInsert            '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('//SqlInsertSqlExec') as Web2Veri(Ent)
    
	 UNION ALL 

			select 
  
			distinct
			          distinct
            l.Name as 'Kutuphane',
			p.Name as 'SurecAdi',
			            p.Name as 'SurecAdi',
            Web2Veri.Ent.value('(./@Connection)[1]','nvarchar(max)') as Adı,
			'SqlUpdate            '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('//SqlUpdateSqlInsert') as Web2Veri(Ent) 

) as Temp order by 1,2
Code Block
languagesql
titleTüm bağlantılar
linenumberstrue
select * from
(
    
 UNION ALL 

	select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            SurecVeriWeb2Veri.Ent.value('(./@Function@Connection)[1]','nvarchar(max)') as Adı,
            'BAPISqlUpdate' as Tipi
    from    wflProcesses p 
		inner  join
            wflLibraries l on l.Id=p.Library 
		inner join (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from
            wflProcessVersions )pv on pv.Id=p.CurrentVersion 
		cross apply pv.Graph
            pv.Graph.nodes('//BAPISqlUpdate') as SurecVeriWeb2Veri(Ent)

) as Temp order UNIONby ALL1,2
Code Block
languagesql
titleRFC çağıran süreçlerin listesini getiren sorgu
select * from
(
	 
    select 
			         distinct
			l.Name  as        l.Name as 'Kutuphane',
			         p.Name as 'SurecAdi',
			WebVeri         SurecVeri.Ent.value('(./@Url@Function)[1]','nvarchar(max)') as Adı,
			'WebInvokeNS         'BAPI' as Tipi
	 
from    from wflProcesses p inner  join
		inner        join wflLibraries l on l.Id=p.Library inner join
		inner join         (select Id, Process,TestMode,Convert convert(XMLxml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from wflProcessVersions) )pv on pv.Id=p.CurrentVersion cross apply
		cross apply         pv.Graph.nodes('//WebInvokeNSBAPI') as WebVeriSurecVeri(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 (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from 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 (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from 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 (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from 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 (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from 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 (select Id,Process,TestMode,Convert(XML,Graph) Graph,Version,CreateDate,LastUpdate,Description from wflProcessVersions )pv on pv.Id=p.CurrentVersion 
	cross apply pv.Graph.nodes('//SqlUpdate') as Web2Veri(Ent)
 
) as Temp order by 1,2
Code Block
languagesql
titleRFC çağıran süreçlerin listesini getiren sorgu
select * from
(
            select 
                    distinct
	 
 UNION ALL 

 
	select 
            distinct
            l.Name as 'Kutuphane',
                    p.Name as 'SurecAdi',
                    SurecVeriWebVeri.Ent.value('(./@Function@Url)[1]','nvarchar(max)') as Adı,
                    'BAPI'WebInvokeNS' as Tipi
            	from    wflProcesses p inner  join
                    wflLibraries l on l.Id=p.Library inner join
                    (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from wflProcessVersions) pv on pv.Id=p.CurrentVersion cross apply
                    pv.Graph.nodes('//BAPIWebInvokeNS') as SurecVeriWebVeri(Ent)
            
 UNION ALL 

 
            	select 
            distinct
            l.Name as 'Kutuphane',
            p.Name as 'SurecAdi',
            WebVeriWeb2Veri.Ent.value('(./@Url)[1]','nvarchar(max)') as Adı,
            'WebInvokeNSJsonInvoke' as Tipi
 
            from    wflProcesses p inner  join
                wflLibraries l on l.Id=p.Library inner join
                (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from wflProcessVersions) pv on pv.Id=p.CurrentVersion cross apply
                pv.Graph.nodes('//WebInvokeNSJsonInvoke') as WebVeriWeb2Veri(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
            (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from 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
            (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from 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
            (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from 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
            (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from 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
            (select Id, Process,TestMode, convert(xml,Graph) as Graph, Version, CreateDate, LastUpdate, Description from wflProcessVersions) pv on pv.Id=p.CurrentVersion cross apply
            pv.Graph.nodes('//SqlUpdate') as Web2Veri(Ent)
 
) as Temp order by 1,2