docs.AntoraNavListRepoObject_by_schema_type - V

type: V ( view ), modify_date: 2021-10-04 21:35:32

RepoObject_guid: 9D8B79D5-B993-EB11-84F2-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.antoranavlistrepoobject_by_schema_type

Columns

Table 1. Columns of docs.AntoraNavListRepoObject_by_schema_type - V
PK Column Name Data Type NULL? ID

1

nvarchar(128)

NOT NULL

2

char(2)

NULL

nvarchar(10)

NOT NULL

nvarchar(max)

NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.antoranavlistrepoobject_by_schema_type

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.antoranavlistrepoobject_by_schema_type

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.antoranavlistrepoobject_by_schema_type

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.antoranavlistrepoobject_by_schema_type

Column Reference Diagram

entity_1_1_colref-docs.antoranavlistrepoobject_by_schema_type

Indexes

PK_AntoraNavListRepoObject_by_schema_type

idx_AntoraNavListRepoObject_by_schema_type__2

idx_AntoraNavListRepoObject_by_schema_type__3

Column Details

_

RepoObject_schema_name

1

RepoObject_schema_name

nvarchar(128)

NOT NULL

type

2

type

char(2)

NULL

cultures_name

cultures_name

nvarchar(10)

NOT NULL

nav_list

nav_list

nvarchar(max)

NULL

type_name

type_name

nvarchar(128)

NULL

sql_modules_definition

docs.AntoraNavListRepoObject_by_schema_type - V script
CREATE View [docs].[AntoraNavListRepoObject_by_schema_type]
As
Select
    ro.RepoObject_schema_name
  , ro.cultures_name
  , type      = ro.SysObject_type
  , type_name = ro.SysObject_type_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)
From
    docs.RepoObject_OutputFilter_T As ro
Where
    ro.is_DocsOutput   = 1
    And ro.is_external = 0
Group By
    ro.RepoObject_schema_name
  , ro.cultures_name
  , ro.SysObject_type
  , ro.SysObject_type_name