docs.ObjectRefCyclic_EntityList - V

CREATE View docs.ObjectRefCyclic_EntityList
As
Select
    rop.cultures_name
  , PumlEntityList       =
  --
  String_Agg ( Cast(rop.RepoObject_Puml As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                       ro.ro_fullname2)
  , PumlEntityOnlyPkList =
  --
  String_Agg ( Cast(rop.RepoObject_PumlOnlyPK As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                             ro.ro_fullname2)
  , XrefEntityList       =
  --
  String_Agg (
                 Concat (
                            --* xref:sqldb:target-page-filename.adoc[link text]
                            --we need to convert to first argument nvarchar(max) to avoid the limit of 8000 byte
                            Cast('* xref:sqldb:' As NVarchar(Max))
                          , docs.fs_cleanStringForFilename ( ro.ro_fullname2 )
                          , '.adoc[]'
                        )
               , Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                ro.ro_fullname2)
From
    docs.RepoObject_Plantuml_Entity_T As rop
    Inner Join
    (
        Select
            ro_guid      = Referenced_guid
          , ro_fullname2 = Referenced_fullname2
        From
            reference.ReferenceTree_cyclic_union
        Union
        Select
            Referencing_guid
          , Referencing_fullname2
        From
            reference.ReferenceTree_cyclic_union
    )                                 As ro
        On
        ro.ro_guid = rop.RepoObject_guid
Group By
    rop.cultures_name

sqlCopied!