docs.RepoObject_OutputFilter - V
type: V ( view ), modify_date: 2021-12-16 11:41:19
RepoObject_guid: ED5BF6C2-0593-EB11-84F2-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_RepoObject_OutputFilter
-
IndexSemanticGroup: RepoObject_guid,cultures_name
-
[column-RepoObject_guid]; uniqueidentifier
-
[column-cultures_name]; nvarchar(10)
-
-
PK, Unique, Real: 1, 1, 0
idx_RepoObject_OutputFilter__1
-
IndexSemanticGroup: no_group
-
[column-RepoObject_schema_name]; nvarchar(128)
-
[column-RepoObject_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_OutputFilter__2
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_OutputFilter__3
-
IndexSemanticGroup: no_group
-
[column-AntoraComponent]; nvarchar(max)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
external_AntoraComponent
external_AntoraComponent |
|
|
external_AntoraModule
external_AntoraModule |
|
|
external_DatabaseName
external_DatabaseName |
|
|
RepoObject_fullname
RepoObject_fullname |
|
|
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
RepoObject_fullname2
RepoObject_fullname2 |
|
|
(concat([RepoObject_schema_name],'.',[RepoObject_name]))
RepoObject_schema_name
RepoObject_schema_name |
|
|
RepoObject_translation
RepoObject_translation |
|
|
sql_modules_definition
docs.RepoObject_OutputFilter - V script
CREATE View docs.RepoObject_OutputFilter
As
Select
ro.RepoObject_guid
, c.cultures_name
, ro.SysObject_type
, ro.SysObject_type_name
, ro.RepoObject_fullname
, ro.RepoObject_fullname2
, RepoObject_FullDisplayName2 = ro.RepoObject_schema_name + '.'
+ Coalesce (
tmt.cultures_translations_model_tables_translatedCaption
, ro.RepoObject_name
)
, RepoObject_DisplayName = Coalesce ( tmt.cultures_translations_model_tables_translatedCaption, ro.RepoObject_name )
, RepoObject_translation = tmt.cultures_translations_model_tables_translatedCaption
, ro.RepoObject_schema_name
, ro.is_DocsOutput
, ro.RepoObject_name
, ro.is_external
, ro.is_ssas
, ro.tables_isHidden
, ro.external_AntoraComponent
, ro.external_AntoraModule
, ro.external_DatabaseName
, ro.AntoraComponent
, ro.AntoraModule
, PumlEntityTopDefault =
--
Concat (
'entity '
---- puml-link:mycomponent:sqldb:config.Event_isInaktiv.adoc[]
---- puml-link:config.Event_isInaktiv.adoc[]
, '"puml-link:' + ro.AntoraComponent + ':' + ro.AntoraModule
+ Iif(ro.is_external = 1, '', Iif(c.cultures_name <> '', '-', '') + c.cultures_name) + ':'
+ docs.fs_cleanStringForFilename ( ro.RepoObject_fullname2 )
--default
+ '.adoc[]"'
, ' as '
, Iif(ro.is_external = 1, ro.AntoraComponent + '.' + ro.AntoraModule + '.', Null)
, docs.fs_cleanStringForPuml ( ro.RepoObject_fullname2 )
, Iif(ro.is_external = 1
, ' <' + Coalesce ( ro.external_DatabaseName, ro.AntoraComponent + ':' + ro.AntoraModule, '' ) + '> '
, Null)
, ' << ' + Iif(ro.is_external = 1, 'external', Trim ( ro.SysObject_type )) + ' >>'
, Iif(ro.tables_isHidden = 1, ' #line.dotted', Iif(ro.is_external = 1, ' #line.dashed', Null))
)
, PumlEntityTopWorkaround =
--
Concat (
'entity '
---- puml-link:mycomponent:sqldb:config.Event_isInaktiv.adoc[]
---- puml-link:config.Event_isInaktiv.adoc[]
, '"puml-link:' + ro.AntoraComponent + ':' + ro.AntoraModule
+ Iif(ro.is_external = 1, '', Iif(c.cultures_name <> '', '-', '') + c.cultures_name) + ':'
+ docs.fs_cleanStringForFilename ( ro.RepoObject_fullname2 )
----workaround empty prefix for #10 - prefix=
+ '.adoc[prefix=]"'
, ' as '
, Iif(ro.is_external = 1, ro.AntoraComponent + '.' + ro.AntoraModule + '.', Null)
, docs.fs_cleanStringForPuml ( ro.RepoObject_fullname2 )
, Iif(ro.is_external = 1
, ' <' + Coalesce ( ro.external_DatabaseName, ro.AntoraComponent + ':' + ro.AntoraModule, '' ) + '> '
, Null)
, ' << ' + Iif(ro.is_external = 1, 'external', Trim ( ro.SysObject_type )) + ' >>'
, Iif(ro.tables_isHidden = 1, ' #line.dotted', Iif(ro.is_external = 1, ' #line.dashed', Null))
)
From
repo.RepoObject_gross As ro
Cross Join docs.Culture As c
Left Join
ssas.model_json_3411_cultures_translations_model_T As tm
On
tm.databasename = ro.RepoObject_schema_name
And tm.cultures_name = c.cultures_name
Left Join
ssas.model_json_34111_cultures_translations_model_tables As tmt
On
tmt.databasename = tm.databasename
And tmt.cultures_name = tm.cultures_name
And tmt.cultures_translations_model_tables_name = ro.RepoObject_name
Where
ro.is_DocsOutput = 1
And ro.is_DocsExclude = 0
And
(
--include all by default
c.cultures_name = ''
--additional include existing culters from tm, per ssas model
Or tm.cultures_name <> ''
)