docs.AntoraNavListRepoObject_by_schema_type - V
type: V ( view ), modify_date: 2021-10-04 21:35:32
RepoObject_guid: 9D8B79D5-B993-EB11-84F2-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
|||
|
|
|||
|
|
Indexes
PK_AntoraNavListRepoObject_by_schema_type
-
IndexSemanticGroup: no_group
-
[column-RepoObject_schema_name]; nvarchar(128)
-
type; char(2)
-
-
PK, Unique, Real: 1, 1, 0
idx_AntoraNavListRepoObject_by_schema_type__2
-
IndexSemanticGroup: no_group
-
[column-cultures_name]; nvarchar(10)
-
-
PK, Unique, Real: 0, 0, 0
idx_AntoraNavListRepoObject_by_schema_type__3
-
IndexSemanticGroup: no_group
-
[column-RepoObject_schema_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
sql_modules_definition
docs.AntoraNavListRepoObject_by_schema_type - V script
CREATE View [docs].[AntoraNavListRepoObject_by_schema_type]
As
Select
ro.RepoObject_schema_name
, ro.cultures_name
, type = ro.SysObject_type
, type_name = ro.SysObject_type_name
, nav_list =
--
String_Agg (
Concat (
--* xref:target-page-filename.adoc[link text]
--we need to convert to first argument nvarchar(max) to avoid the limit of 8000 byte
Cast('* xref:' As NVarchar(Max))
, docs.fs_cleanStringForFilename ( ro.RepoObject_fullname2 )
, '.adoc[]'
)
, Char ( 13 ) + Char ( 10 )
) Within Group(Order By
ro.RepoObject_DisplayName)
From
docs.RepoObject_OutputFilter_T As ro
Where
ro.is_DocsOutput = 1
And ro.is_external = 0
Group By
ro.RepoObject_schema_name
, ro.cultures_name
, ro.SysObject_type
, ro.SysObject_type_name