docs.AntoraPage_IndexSemanticGroup - V
type: V ( view ), modify_date: 2022-09-08 16:15:45
RepoObject_guid: 8A1293B9-DE96-EB11-84F4-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
|
|
Indexes
PK_AntoraPage_IndexSemanticGroup
-
IndexSemanticGroup: no_group
-
[column-page_content]; nvarchar(max)
-
-
PK, Unique, Real: 1, 1, 0
idx_AntoraPage_IndexSemanticGroup__2
-
IndexSemanticGroup: no_group
-
[column-cultures_name]; nvarchar(10)
-
-
PK, Unique, Real: 0, 0, 0
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