docs.ssis_navlist_package - V

create View docs.ssis_navlist_package
As
Select
    AntoraModule
  , nav_list =
  --
  String_Agg (
                 Concat (
                            --* xref:target-page-filename.adoc[link text]
                            --we need to convert to first argument nvarchar(max) to avoid the limit of 8000 byte
                            Cast('* xref:' As NVarchar(Max))
                          , docs.fs_cleanStringForFilename ( PackageBasename )
                          , '.adoc[]'
                        )
               , Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                PackageBasename)
From
    ssis.Package
Group By
    AntoraModule