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
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
3 |
|
|
||
|
|
|||
|
|
|||
|
|
Indexes
PK_model_json_3411_cultures_translations_model
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-cultures_name]; nvarchar(500)
-
[column-cultures_translations_model_name]; nvarchar(500)
-
-
PK, Unique, Real: 1, 1, 0
idx_model_json_3411_cultures_translations_model__2
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-cultures_name]; nvarchar(500)
-
-
PK, Unique, Real: 0, 0, 0
idx_model_json_3411_cultures_translations_model__3
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
cultures_translations_model_perspectives_ja
cultures_translations_model_perspectives_ja |
|
|
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