docs.AntoraPage_ObjectBySchema - V

type: V ( view ), modify_date: 2022-09-08 16:10:10

RepoObject_guid: AF5A9DE2-3799-EB11-84F5-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.antorapage_objectbyschema

Columns

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

nvarchar(10)

NOT NULL

nvarchar(max)

NOT NULL

nvarchar(max)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-docs.antorapage_objectbyschema

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.antorapage_objectbyschema

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.antorapage_objectbyschema

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.antorapage_objectbyschema

Column Reference Diagram

entity_1_1_colref-docs.antorapage_objectbyschema

Indexes

idx_AntoraPage_ObjectBySchema__1

Column Details

_

cultures_name

cultures_name

nvarchar(10)

NOT NULL

page_content

page_content

nvarchar(max)

NOT NULL

partial_content

partial_content

nvarchar(max)

NOT NULL

sql_modules_definition

docs.AntoraPage_ObjectBySchema - V script
/*
output example partial_content:

* Objects by schema
** xref:nav/nav-schema-dbo.adoc[]
+
--
include::partial$navlist/navlist-schema_dbo.adoc[]
--

output example page_content:

= Objects by schema

include::nav-schema-CFG.adoc[leveloffset=+1]

include::nav-schema-Config.adoc[leveloffset=+1]

include::nav-schema-ConfigH.adoc[leveloffset=+1]

*/
CREATE View docs.AntoraPage_ObjectBySchema
As
Select
    ro.cultures_name
  , partial_content
  --
  = Concat (
               '* xref:nav/objects-by-schema.adoc[]'
             , Char ( 13 ) + Char ( 10 )
             , String_Agg (
                              Concat (
                                         Cast('' As NVarchar(Max))
                                       , '** xref:nav/nav-schema-'
                                         + docs.fs_cleanStringForFilename ( ro.RepoObject_schema_name ) + '.adoc[]'
                                       , Char ( 13 ) + Char ( 10 )
                                       , '+'
                                       , Char ( 13 ) + Char ( 10 )
                                       , '--'
                                       , Char ( 13 ) + Char ( 10 )
                                       , '\include::partial$navlist/navlist-schema-'
                                         + docs.fs_cleanStringForFilename ( ro.RepoObject_schema_name ) + '.adoc[]'
                                       , Char ( 13 ) + Char ( 10 )
                                       , '--'
                                     )
                            , Char ( 13 ) + Char ( 10 )
                          ) Within Group(Order By
                                             ro.RepoObject_schema_name)
           )
  , page_content
  --
  = Concat (
               Iif(Max ( ro.is_ssas ) = 1
                 , '= SSAS Tabular Models' + Iif(ro.cultures_name <> '', ' - ' + ro.cultures_name, '')
                 , '= ' + config.fs_dwh_database_name () + ' - Objects by schema')
             , Char ( 13 ) + Char ( 10 )
             , Char ( 13 ) + Char ( 10 )
             , String_Agg (
                              Concat (
                                         Cast('' As NVarchar(Max))
                                       , '\include::nav-schema-'
                                         + docs.fs_cleanStringForFilename ( ro.RepoObject_schema_name )
                                         + '.adoc[leveloffset=+1]'
                                     )
                            , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          ) Within Group(Order By
                                             ro.RepoObject_schema_name)
           )
From
    docs.AntoraNavListRepoObject_by_schema As ro
Group By
    ro.cultures_name