docs.RepoObject_AntoraXrefCulturesList

Description

Examples

Entity Diagram

Columns

Table 1. Columns of docs.RepoObject_AntoraXrefCulturesList - V
Column Name	Data Type	NULL?
AntoraXrefCulturesList	`nvarchar(max)`	`NULL`
cultures_count	`int`	`NULL`
RepoObject_guid	`uniqueidentifier`	`NOT NULL`

Foreign Key Diagram

References

Referenced Objects

Referencing Objects

docs.RepoObject_Adoc - V

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

idx_RepoObject_AntoraXrefCulturesList__1

IndexSemanticGroup: no_group
- [column-RepoObject_guid]; uniqueidentifier
PK, Unique, Real: 0, 0, 0

Column Details

_

AntoraXrefCulturesList

nvarchar(max)

NULL

cultures_count

int

NULL

RepoObject_guid

uniqueidentifier

NOT NULL

Referenced Columns

docs.RepoObject_OutputFilter_T.RepoObject_guid

sql_modules_definition

docs.RepoObject_AntoraXrefCulturesList - V script

CREATE View docs.RepoObject_AntoraXrefCulturesList
As
Select
    rof.RepoObject_guid
  , AntoraXrefCulturesList = String_Agg (   Cast('* ' As NVarchar(Max)) + ax.AntoraXrefComponentModule
                                            --
                                            + ' - ' + rof.cultures_name
                                          , Char ( 13 ) + Char ( 10 )
                                        ) Within Group(Order By
                                                           rof.cultures_name)
  , cultures_count         = Count ( 1 )
From
    docs.RepoObject_OutputFilter_T                                                        As rof
    Cross Apply docs.ftv_RepoObject_AntoraXref ( rof.RepoObject_guid, rof.cultures_name ) As ax
Group By
    rof.RepoObject_guid