docs.ssis_PumlPartialControlFlows - V

type: V ( view ), modify_date: 2021-11-07 10:34:15

RepoObject_guid: ACDCAD7F-F73E-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.ssis_pumlpartialcontrolflows

Columns

Table 1. Columns of docs.ssis_PumlPartialControlFlows - V
PK Column Name Data Type NULL? ID

AntoraModule

varchar(50)

NOT NULL

PackageName

varchar(200)

NOT NULL

PumlPartialControlFlows

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.ssis_pumlpartialcontrolflows

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.ssis_pumlpartialcontrolflows

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.ssis_pumlpartialcontrolflows

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.ssis_pumlpartialcontrolflows

Column Reference Diagram

entity_1_1_colref-docs.ssis_pumlpartialcontrolflows

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL
Referenced Columns

PackageName

PackageName

varchar(200)

NOT NULL
Referenced Columns

PumlPartialControlFlows

PumlPartialControlFlows

nvarchar(max)

NULL

sql_modules_definition

docs.ssis_PumlPartialControlFlows - V script 
CREATE View docs.ssis_PumlPartialControlFlows
As
Select
    pf.AntoraModule
  , pf.PackageName
  , PumlPartialControlFlows =
  --
  String_Agg (
                 Cast(N'' As NVarchar(Max)) + docs.fs_cleanStringForAnchorId ( pf.TaskFrom )
                 + Iif(pf.LogicalAnd = 1, ' --> ', ' ..> ') + docs.fs_cleanStringForAnchorId ( pf.Taskto )
                 + Iif(pf.Expression <> '', ' : ' + pf.Expression, '')
               , Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                pf.TaskFrom
                              , pf.Taskto)
From
    ssis.PackageFlow As pf
Where
    pf.FlowType = 'Control Flow'
Group By
    pf.AntoraModule
  , pf.PackageName