docs.AntoraPage_ObjectByType - V

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

RepoObject_guid: 871293B9-DE96-EB11-84F4-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.antorapage_objectbytype

Columns

Table 1. Columns of docs.AntoraPage_ObjectByType - 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_objectbytype

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.antorapage_objectbytype

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.antorapage_objectbytype

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.antorapage_objectbytype

Column Reference Diagram

entity_1_1_colref-docs.antorapage_objectbytype

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_ObjectByType - V script
/*
output example:

* Objects by type
** xref:nav/nav-type-U.adoc[]
+
--
include::partial$navlist/navlist-type-U.adoc[]
--

*/
CREATE View docs.AntoraPage_ObjectByType
As
Select
    existing.cultures_name
  , partial_content = Concat (
                                 '* Objects by type'
                               , Char ( 13 ) + Char ( 10 )
                               , String_Agg (
                                                Concat (
                                                           Cast('' As NVarchar(Max))
                                                         , '** xref:nav/nav-type-'
                                                           + docs.fs_cleanStringForFilename ( ct.type ) + '.adoc[]'
                                                         , Char ( 13 ) + Char ( 10 )
                                                         , '+'
                                                         , Char ( 13 ) + Char ( 10 )
                                                         , '--'
                                                         , Char ( 13 ) + Char ( 10 )
                                                         , '\include::partial$navlist/navlist-type-'
                                                           + docs.fs_cleanStringForFilename ( ct.type ) + '.adoc[]'
                                                         , Char ( 13 ) + Char ( 10 )
                                                         , '--'
                                                       )
                                              , Char ( 13 ) + Char ( 10 )
                                            ) Within Group(Order By
                                                               ct.type_desc Desc)
                             )
  , page_content
  --
                    = Concat (
                                 '= ' + config.fs_dwh_database_name () + ' - Objects by type'
                               , Char ( 13 ) + Char ( 10 )
                               , Char ( 13 ) + Char ( 10 )
                               , String_Agg (
                                                Concat (
                                                           Cast('' As NVarchar(Max))
                                                         , '\include::nav-type-' + docs.fs_cleanStringForFilename ( ct.type )
                                                           + '.adoc[leveloffset=+1]'
                                                       )
                                              , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                                            ) Within Group(Order By
                                                               ct.type_desc Desc)
                             )
From
    configT.type                             As ct
    --only existing objects
    Inner Join
        docs.AntoraNavListRepoObject_by_type As existing
            On
            existing.type = ct.type
Where
    ( ct.is_DocsOutput = 1 )
Group By
    existing.cultures_name