docs.ssis_PumlPartialControlFlows - V
type: V ( view ), modify_date: 2021-11-07 10:34:15
RepoObject_guid: ACDCAD7F-F73E-EC11-852D-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
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
sql