docs.RepoObject_IndexList - V

type: V ( view ), modify_date: 2022-01-05 18:06:35

RepoObject_guid: 6FE2B548-5E96-EB11-84F4-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.repoobject_indexlist

Columns

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

1

uniqueidentifier

NULL

2

nvarchar(10)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.repoobject_indexlist

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.repoobject_indexlist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.repoobject_indexlist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.repoobject_indexlist

Column Reference Diagram

entity_1_1_colref-docs.repoobject_indexlist

Indexes

PK_RepoObject_IndexList

UK_RepoObject_IndexList__1

idx_RepoObject_IndexList__3

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NULL

cultures_name

2

cultures_name

nvarchar(10)

NULL

AntoraIndexList

AntoraIndexList

nvarchar(max)

NULL

PumlIndexList

PumlIndexList

nvarchar(max)

NULL

sql_modules_definition

docs.RepoObject_IndexList - V script
CREATE View docs.RepoObject_IndexList
As
Select
    RepoObject_guid = ix.parent_RepoObject_guid
  , rof.cultures_name
  , AntoraIndexList =
  --
  String_Agg (
                 Concat (
                            --we need to convert to first argument nvarchar(max) to avoid the limit of 8000 byte
                            Cast('' As NVarchar(Max))
                          , Char ( 13 ) + Char ( 10 )
                          , '[#index-'
                          --, '[id=index-'
                          --, '[[index-' --deprecated
                          , docs.fs_cleanStringForAnchorId ( ix.index_name )
                          --, ']]'
                          , ']'
                          , Char ( 13 ) + Char ( 10 )
                          , '=== '
                          --, ix.index_name
                          , docs.fs_cleanStringForHeader ( ix.index_name )
                          , Char ( 13 ) + Char ( 10 )
                          , Char ( 13 ) + Char ( 10 )
                          , '* IndexSemanticGroup: ' + 'xref:other/indexsemanticgroup.adoc#'
                            + docs.fs_cleanStringForAnchorId ( IsNull ( ix.IndexSemanticGroup, '(no group)' )) + '['
                            + IsNull ( ix.IndexSemanticGroup, 'no_group' ) + ']'
                          , Char ( 13 ) + Char ( 10 )
                          , '+' + Char ( 13 ) + Char ( 10 )
                          , '--' + Char ( 13 ) + Char ( 10 )
                          , ix.AntoraIndexColumnList
                          , Char ( 13 ) + Char ( 10 )
                          , '--' + Char ( 13 ) + Char ( 10 )
                          , '* PK, Unique, Real: '
                          , ix.is_index_primary_key
                          , ', '
                          , ix.is_index_unique
                          , ', '
                          , ix.is_index_real
                          , Char ( 13 ) + Char ( 10 )
                          , '* ' + fk.referenced_AntoraXref + Char ( 13 ) + Char ( 10 )
                          , Iif(ix.is_index_disabled = 1, '* is disabled' + Char ( 13 ) + Char ( 10 ), Null)
                        )
               , Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                ix.is_index_primary_key Desc
                              , ix.is_index_unique Desc
                              , ix.index_name)
  , PumlIndexList   =
  --
  String_Agg (
                 Concat (
                            Cast('' As NVarchar(Max))
                          , Iif(ix.is_index_real = 0, '- ', Null)
                          , Iif(ix.is_index_primary_key = 1, '**', Null)
                          , docs.fs_cleanStringForPuml ( ix.index_name )
                          , Iif(ix.is_index_primary_key = 1, '**', Null)
                          , Char ( 13 ) + Char ( 10 )
                          , '"' + ix.IndexSemanticGroup + '"'
                          , Char ( 13 ) + Char ( 10 )
                          , '..'
                          , Char ( 13 ) + Char ( 10 )
                          , ix.PumlIndexColumnList
                        )
               , Char ( 13 ) + Char ( 10 ) + '--' + Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                ix.is_index_primary_key Desc
                              , ix.is_index_unique Desc
                              , ix.index_name)
From
    repo.Index_gross                   As ix
    Left Join
        repo.ForeignKey_gross          As fk
            On
            fk.referencing_index_guid = ix.index_guid

    Left Join
        docs.RepoObject_OutputFilter_T As rof
            On
            rof.RepoObject_guid       = ix.parent_RepoObject_guid
Where
    Not rof.cultures_name Is Null
Group By
    ix.parent_RepoObject_guid
  , rof.cultures_name