docs.AntoraNavListPage_by_schema - V

Description

Examples

Entity Diagram

Columns

Table 1. Columns of docs.AntoraNavListPage_by_schema - V
Column Name	Data Type	NULL?
cultures_name	`nvarchar(10)`	`NULL`
nav_list	`nvarchar(max)`	`NOT NULL`
RepoObject_schema_name	`nvarchar(128)`	`NOT NULL`

Foreign Key Diagram

References

Referenced Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

idx_AntoraNavListPage_by_schema__1

IndexSemanticGroup: no_group
- [column-RepoObject_schema_name]; nvarchar(128)
PK, Unique, Real: 0, 0, 0

idx_AntoraNavListPage_by_schema__2

IndexSemanticGroup: no_group
- [column-cultures_name]; nvarchar(10)
PK, Unique, Real: 0, 0, 0

Column Details

_

cultures_name

nvarchar(10)

NULL

Referenced Columns

docs.RepoObject_OutputFilter_T.cultures_name

nav_list

nvarchar(max)

NOT NULL

RepoObject_schema_name

nvarchar(128)

NOT NULL

Referenced Columns

repo.RepoObject.RepoObject_schema_name

sql_modules_definition

docs.AntoraNavListPage_by_schema - V script

CREATE View docs.AntoraNavListPage_by_schema
As
Select
    ro.RepoObject_schema_name
  , rof.cultures_name
  , nav_list =
  --
  Concat (
             '= '
           , ro.RepoObject_schema_name
           , Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 )
           , '== Description'
           , Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 )
           , Max ( rs.RepoSchema_description )
           , Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 )
           , '== Objects'
           , 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 )
           , Iif(Max ( Cast(rs.is_ssas As Int)) = 1
               , Concat (
                            Char ( 13 ) + Char ( 10 )
                          , '== SSAS Relations Diagram'
                          , Char ( 13 ) + Char ( 10 )
                          , Char ( 13 ) + Char ( 10 )
                          , '[plantuml, schema_ssas_er-' + ro.RepoObject_schema_name + ', svg, subs=macros]'
                          , Char ( 13 ) + Char ( 10 )
                          , '....'
                          , Char ( 13 ) + Char ( 10 )
                          --, '\include::partial$puml/schema_ssas_er/'
                          --  + docs.fs_cleanStringForFilename ( ro.RepoObject_schema_name ) + '.puml[]'
                          , Max ( puml.PumlSchemaSsasEr )
                          , Char ( 13 ) + Char ( 10 )
                          , '....'
                          , Char ( 13 ) + Char ( 10 )
                        )
               , Null)
         )
From
    repo.RepoObject                    As ro
    Left Join
        repo.RepoSchema                As rs
            On
            rs.RepoSchema_name     = ro.RepoObject_schema_name

    Left Join
        docs.RepoObject_OutputFilter_T As rof
            On
            rof.RepoObject_guid    = ro.RepoObject_guid

    Left Join
        docs.Schema_puml               As puml
            On
            puml.RepoSchema_guid   = rs.RepoSchema_guid
            And puml.cultures_name = rof.cultures_name
Where
    rof.is_external       = 0
    And rof.is_DocsOutput = 1
Group By
    ro.RepoObject_schema_name
  , rof.cultures_name