docs.AntoraNavListRepoObject_by_schema - V

CREATE View docs.AntoraNavListRepoObject_by_schema
As
Select
    ro.RepoObject_schema_name
  , ro.cultures_name
  , 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 ( ro.RepoObject_fullname2 )
                          , '.adoc[]'
                        )
               , Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                ro.RepoObject_DisplayName)
  , is_ssas  = Max ( Cast(ro.is_ssas As TinyInt))
From
    docs.RepoObject_OutputFilter_T As ro
Where
    ro.is_external = 0
Group By
    ro.RepoObject_schema_name
  , ro.cultures_name