docs.RepoObject_OutputFilter - V

type: V ( view ), modify_date: 2021-12-16 11:41:19

RepoObject_guid: ED5BF6C2-0593-EB11-84F2-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.repoobject_outputfilter

Columns

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

1

uniqueidentifier

NOT NULL

2

nvarchar(10)

NOT NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

int

NULL

bit

NOT NULL

bit

NOT NULL

nvarchar(max)

NOT NULL

nvarchar(max)

NOT NULL

nvarchar(128)

NULL

nvarchar(257)

NULL

nvarchar(261)

NOT NULL

nvarchar(257)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NULL

char(2)

NULL

nvarchar(128)

NULL

bit

NULL

Foreign Key Diagram

entity_1_1_fk-docs.repoobject_outputfilter

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.repoobject_outputfilter

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.repoobject_outputfilter

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.repoobject_outputfilter

Column Reference Diagram

entity_1_1_colref-docs.repoobject_outputfilter

Indexes

PK_RepoObject_OutputFilter

idx_RepoObject_OutputFilter__1

idx_RepoObject_OutputFilter__2

idx_RepoObject_OutputFilter__3

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL

cultures_name

2

cultures_name

nvarchar(10)

NOT NULL

Referenced Columns

AntoraComponent

AntoraComponent

nvarchar(max)

NULL

AntoraModule

AntoraModule

nvarchar(max)

NULL

external_AntoraComponent

external_AntoraComponent

nvarchar(128)

NULL

external_AntoraModule

external_AntoraModule

nvarchar(128)

NULL

external_DatabaseName

external_DatabaseName

nvarchar(128)

NULL

is_DocsOutput

is_DocsOutput

int

NULL

is_external

is_external

bit

NOT NULL

is_ssas

is_ssas

bit

NOT NULL

Referenced Columns

PumlEntityTopDefault

PumlEntityTopDefault

nvarchar(max)

NOT NULL

PumlEntityTopWorkaround

PumlEntityTopWorkaround

nvarchar(max)

NOT NULL

RepoObject_DisplayName

RepoObject_DisplayName

nvarchar(128)

NULL

RepoObject_FullDisplayName2

RepoObject_FullDisplayName2

nvarchar(257)

NULL

RepoObject_fullname

RepoObject_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


RepoObject_fullname2

RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

(concat([RepoObject_schema_name],'.',[RepoObject_name]))


RepoObject_name

RepoObject_name

nvarchar(128)

NOT NULL

RepoObject_schema_name

RepoObject_schema_name

nvarchar(128)

NOT NULL

SysObject_type

SysObject_type

char(2)

NULL

SysObject_type_name

SysObject_type_name

nvarchar(128)

NULL

tables_isHidden

tables_isHidden

bit

NULL

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 <> ''
    )