docs.AntoraPage_IndexSemanticGroup - V

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

RepoObject_guid: 8A1293B9-DE96-EB11-84F4-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.antorapage_indexsemanticgroup

Columns

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

1

nvarchar(max)

NOT NULL

nvarchar(10)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.antorapage_indexsemanticgroup

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.antorapage_indexsemanticgroup

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.antorapage_indexsemanticgroup

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.antorapage_indexsemanticgroup

Column Reference Diagram

entity_1_1_colref-docs.antorapage_indexsemanticgroup

Indexes

PK_AntoraPage_IndexSemanticGroup

idx_AntoraPage_IndexSemanticGroup__2

Column Details

_

page_content

1

page_content

nvarchar(max)

NOT NULL

cultures_name

cultures_name

nvarchar(10)

NULL

sql_modules_definition

docs.AntoraPage_IndexSemanticGroup - V script
CREATE View docs.AntoraPage_IndexSemanticGroup
As
Select
    cultures_name
  , page_content =
  --
  Concat (
             '= Index SemanticGroup'
           , Char ( 13 ) + Char ( 10 )
           , String_Agg ( Cast(AntoraIndexSemanticgroup As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                                       IsNull (
                                                                                                                                  IndexSemanticGroup
                                                                                                                                , 'zzzzzzz'
                                                                                                                              ))
         )
From
    docs.IndexSemanticgroup
Group By
    cultures_name