docs.RepoObject_OutputFilter_T_gross - V

type: V ( view ), modify_date: 2021-12-03 18:25:18

RepoObject_guid: A3C25376-1355-EC11-8533-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.repoobject_outputfilter_t_gross

Columns

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

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(10)

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(4000)

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

uniqueidentifier

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_t_gross

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.repoobject_outputfilter_t_gross

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.repoobject_outputfilter_t_gross

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.repoobject_outputfilter_t_gross

Column Reference Diagram

entity_1_1_colref-docs.repoobject_outputfilter_t_gross

Indexes

idx_RepoObject_OutputFilter_T_gross__1

idx_RepoObject_OutputFilter_T_gross__2

idx_RepoObject_OutputFilter_T_gross__3

idx_RepoObject_OutputFilter_T_gross__4

Column Details

_

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

FilenameRelatedMeasures

FilenameRelatedMeasures

nvarchar(4000)

NULL

Description

(case when [is_ssas]=(1) then [docs].[fs_cleanStringForFilename]([RepoObject_schema_name]+'._measures') end)


is_DocsOutput

is_DocsOutput

int

NULL

is_external

is_external

bit

NOT NULL

is_ssas

is_ssas

bit

NOT NULL

PumlEntityTopDefault

PumlEntityTopDefault

nvarchar(max)

NOT NULL

PumlEntityTopWorkaround

PumlEntityTopWorkaround

nvarchar(max)

NOT 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_guid

RepoObject_guid

uniqueidentifier

NOT NULL

RepoObject_name

RepoObject_name

nvarchar(128)

NOT NULL

RepoObject_schema_name

RepoObject_schema_name

nvarchar(128)

NOT NULL

RepoObject_translation

RepoObject_translation

nvarchar(128)

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_T_gross - V script
Create View docs.RepoObject_OutputFilter_T_gross
As
Select
    RepoObject_guid
  , cultures_name
  , SysObject_type
  , SysObject_type_name
  , RepoObject_fullname
  , RepoObject_fullname2
  , RepoObject_FullDisplayName2
  , RepoObject_DisplayName
  , RepoObject_translation
  , RepoObject_schema_name
  , is_DocsOutput
  , RepoObject_name
  , is_external
  , is_ssas
  , tables_isHidden
  , external_AntoraComponent
  , external_AntoraModule
  , external_DatabaseName
  , AntoraComponent
  , AntoraModule
  , PumlEntityTopDefault
  , PumlEntityTopWorkaround
  , FilenameRelatedMeasures = Case
                                  When is_ssas = ( 1 )
                                      Then
                                      docs.fs_cleanStringForFilename ( RepoObject_schema_name + '._measures' )
                              End
From
    docs.RepoObject_OutputFilter_T