docs.ssis_DftTaskComponentInputColumnList - V

CREATE View docs.ssis_DftTaskComponentInputColumnList
As
Select
    T1.AntoraModule
  , T1.PackageName
  , T1.TaskPath
  , T1.Component_refId
  , T1.input_refId
  , DftTaskComponentInputColumnList =
  --
  Concat (
             N''
           --table start
           , '.Columns of ' + T1.input_refId + Char ( 13 ) + Char ( 10 )
           , '[cols="2,1l,4"]' + Char ( 13 ) + Char ( 10 )
           , '|===' + Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 )
           --
           --table content
           , String_Agg (
                            Concat (
                                       Cast(N'' As NVarchar(Max))
                                     --inline Anchor ID sysntax:
                                     --[[bookmark-a]]Inline anchors make arbitrary content referenceable.
                                     --not working:
                                     --[#bookmark-b]#Inline anchors can be applied to a phrase like this one.#
                                     , '|' + '[[dftcomponentcolumn-'
                                       + docs.fs_cleanStringForAnchorId ( T1.Column_refId ) + ']]'
                                     , docs.fs_cleanStringForHeader ( T1.Column_cachedName )
                                     , Iif(T2.Column_name <> T1.Column_cachedName, ' (' + T2.Column_name + ')', '')
                                     , Char ( 13 ) + Char ( 10 )
                                     , '|' + T1.Column_cachedDataType
                                     , Iif(T2.Column_dataType <> T1.Column_cachedDataType
                                           , ' - ' + T2.Column_dataType + ''
                                           , '')
                                     , '(' + Cast(T2.Column_length As Varchar(10)) + ')'
                                     , '(' + Cast(T2.Column_precision As Varchar(10)) + ','
                                     , Cast(T2.Column_scale As Varchar(10)) + ')'
                                     , Char ( 13 ) + Char ( 10 )
                                     , '|'
                                     , ' <<dftcomponentcolumn-'
                                       + docs.fs_cleanStringForAnchorId ( T1.Column_lineageId )
                                       --Cross reference with custom xreflabel text
                                       + ',' + docs.fs_cleanStringForHeader ( T1.Column_lineageId ) + '>>'
                                     , Char ( 13 ) + Char ( 10 )
                                   )
                          , Char ( 13 ) + Char ( 10 )
                        ) Within Group(Order By
                                           T1.Column_refId)

           --table end
           , '|===' + Char ( 13 ) + Char ( 10 )
         )
From
    ssis.PackageTask_Dft_Component_input_inputColumn                As T1
    Left Join
        ssis.PackageTask_Dft_Component_input_externalMetadataColumn As T2
            On
            T2.AntoraModule     = T1.AntoraModule
            And T2.PackageName  = T1.PackageName
            And T2.Column_refId = T1.Column_externalMetadataColumnId
Group By
    T1.AntoraModule
  , T1.PackageName
  , T1.TaskPath
  , T1.Component_refId
  , T1.input_refId