ssas.model_json_3411_cultures_translations_model - V

type: V ( view ), modify_date: 2021-09-01 07:00:01

RepoObject_guid: FE5FD8EE-E90A-EC11-8516-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.model_json_3411_cultures_translations_model

Columns

Table 1. Columns of ssas.model_json_3411_cultures_translations_model - V
PK Column Name Data Type NULL? ID

1

nvarchar(128)

NOT NULL

2

nvarchar(500)

NULL

3

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_3411_cultures_translations_model

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_3411_cultures_translations_model

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_3411_cultures_translations_model

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_3411_cultures_translations_model

Column Reference Diagram

entity_1_1_colref-ssas.model_json_3411_cultures_translations_model

Indexes

PK_model_json_3411_cultures_translations_model

idx_model_json_3411_cultures_translations_model__2

idx_model_json_3411_cultures_translations_model__3

Column Details

_

databasename

1

databasename

nvarchar(128)

NOT NULL

cultures_name

2

cultures_name

nvarchar(500)

NULL

cultures_translations_model_name

3

cultures_translations_model_name

nvarchar(500)

NULL

cultures_translations_model_perspectives_ja

cultures_translations_model_perspectives_ja

nvarchar(max)

NULL

cultures_translations_model_tables_ja

cultures_translations_model_tables_ja

nvarchar(max)

NULL

cultures_translations_model_translatedDescription

cultures_translations_model_translatedDescription

nvarchar(max)

NULL

sql_modules_definition

ssas.model_json_3411_cultures_translations_model - V script
/*
--get and check existing values

Select
    Distinct
    j2.[Key]
  , j2.Type
From
    ssas.model_json_341_cultures_translations As T1
    Cross Apply OpenJson ( T1.cultures_translations_model_j )
                --As j1
                --Cross Apply OpenJson ( j1.Value )
                                As j2
order by
    j2.[Key]
  , j2.Type
Go
*/
CREATE View [ssas].[model_json_3411_cultures_translations_model]
As
Select
    T1.databasename
  , T1.cultures_name
  --, T1.cultures_translations_model_j
  , j2.cultures_translations_model_name
  , j2.cultures_translations_model_perspectives_ja
  , j2.cultures_translations_model_tables_ja
  , j2.cultures_translations_model_translatedDescription
From
    ssas.model_json_341_cultures_translations As T1
    Cross Apply
    OpenJson ( T1.cultures_translations_model_j )
    --As j1
    --Cross Apply
    --OpenJson ( j1.Value )
    With
    (
        cultures_translations_model_name NVarchar ( 500 ) N'$.name'
      , cultures_translations_model_perspectives_ja NVarchar ( Max ) N'$.perspectives' As Json
      , cultures_translations_model_tables_ja NVarchar ( Max ) N'$.tables' As Json
      , cultures_translations_model_translatedDescription NVarchar ( Max ) N'$.translatedDescription'
    )                                         As j2