configT.InheritanceType - V
type: V ( view ), modify_date: 2021-10-02 13:23:33
RepoObject_guid: 5CB33A4A-426D-EB11-84E2-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
|
|
Indexes
PK_InheritanceType
-
IndexSemanticGroup: no_group
-
PK, Unique, Real: 1, 1, 0
sql_modules_definition
configT.InheritanceType - V script
/*
<<property_start>>Description
<<property_end>>
*/
CREATE View configT.InheritanceType
As
Select
InheritanceType = 0
, InheritanceTypeDescription = 'No inheritance from predecessor'
Union All
Select
InheritanceType = 11
, InheritanceTypeDescription = 'Inheritance from first (or all) predecessor, if current value is NULL'
Union All
Select
InheritanceType = 12
, InheritanceTypeDescription = 'Inheritance from first (or all) predecessor, if current value is NULL or empty ('''')'
Union All
Select
InheritanceType = 13
, InheritanceTypeDescription = 'Inheritance from first (or all) predecessor, forced, only when source is not empty'
Union All
Select
InheritanceType = 14
, InheritanceTypeDescription = 'Inheritance from first (or all) predecessor, forced without exception (dangerous!)';
--UNION ALL
--SELECT
-- [InheritanceType] = 21
-- , [InheritanceTypeDescription] = 'Inheritance from all predecessors - STRING_AGG(xyz, CHAR(13)+CHAR(10)), if current value is NULL'
--UNION ALL
--SELECT
-- [InheritanceType] = 22
-- , [InheritanceTypeDescription] = 'Inheritance from all predecessors - STRING_AGG(xyz, CHAR(13)+CHAR(10)), if current value is NULL or empty ('''')'
--UNION ALL
--SELECT
-- [InheritanceType] = 23
-- , [InheritanceTypeDescription] = 'Inheritance from all predecessors - STRING_AGG(xyz, CHAR(13)+CHAR(10)), forced, only when source is not empty'
--UNION ALL
--SELECT
-- [InheritanceType] = 24
-- , [InheritanceTypeDescription] = 'Inheritance from all predecessors - STRING_AGG(xyz, CHAR(13)+CHAR(10)), forced without exception (dangerous!)'
----still unclear if and how this could or should be implemented
----additional parameters for CONCAT String required
--UNION ALL
--SELECT
-- [InheritanceType] = 31
-- , [InheritanceTypeDescription] = 'use CONCAT (for example: ''[RepoObject_name],CHAR(13),CHAR(10),EineNochZuDefinierendeFunktion(''MS_Description'')''), Inheritance from first predecessor, if current value is NULL'
--UNION ALL
--SELECT
-- [InheritanceType] = 32
-- , [InheritanceTypeDescription] = 'use CONCAT (for example: ''[RepoObject_name],CHAR(13),CHAR(10),EineNochZuDefinierendeFunktion(''MS_Description'')''), Inheritance from first predecessor, if current value is NULL or empty ('''')'
--UNION ALL
--SELECT
-- [InheritanceType] = 33
-- , [InheritanceTypeDescription] = 'use CONCAT (for example: ''[RepoObject_name],CHAR(13),CHAR(10),EineNochZuDefinierendeFunktion(''MS_Description'')''), Inheritance from first predecessor, force'