bug #6343
TermVocabularies of OrderedTerms must be OrderedVocabularies
Start date:
01/18/2017
Due date:
% Done:
0%
Severity:
normal
Found in Version:
Description
Updatescript for TermVocabularies of OrderedTerms which are not OrderedVocabularies.
See also https://dev.e-taxonomy.eu/redmine/issues/4821#note-8
===
Otherwise the terms of the following types need to be unordered (see #7340)
Therefore the following script needs to run for them:
UPDATE TermVocabulary
SET DTYPE = 'TermVocabulary'
WHERE termType IN ('SEX', 'DMO', 'MO', 'STG', 'SCO');
UPDATE DefinedTermBase
SET orderIndex = NULL
WHERE termType IN ('SEX', 'DMO', 'MO', 'STG', 'SCO');
Also we may want to set the uri and some iso fields to NULL where empty (see #7445):
UPDATE DefinedTermBase
SET uri = null
WHERE Trim(uri) = '';
UPDATE DefinedTermBase
SET iso639_1 = null
WHERE Trim(iso639_1) = '';
UPDATE DefinedTermBase
SET iso3166_A2 = null
WHERE Trim(iso3166_A2) = '';
UPDATE TermVocabulary
SET uri = null
WHERE Trim(uri) = '';
I did run these scripts on production, integration and test.
Related issues
History
#1 Updated by Andreas Müller about 4 years ago
- Due date set to 04/30/2015
- Start date changed from 01/18/2017 to 04/30/2015
#2 Updated by Andreas Müller about 4 years ago
- Due date deleted (
04/30/2015) - Status changed from New to In Progress
- Priority changed from New to Highest
- Start date changed from 04/30/2015 to 01/18/2017
#3 Updated by Andreas Müller about 4 years ago
- Subject changed from TermVocabularies of OrderedTerms must be OrderedVocabulares, Updatescript to TermVocabularies of OrderedTerms must be OrderedVocabulares
#4 Updated by Andreas Müller over 3 years ago
- Target version changed from CDM UML 4.7 to CDM UML 5.0
#5 Updated by Andreas Müller over 2 years ago
- Subject changed from TermVocabularies of OrderedTerms must be OrderedVocabulares to TermVocabularies of OrderedTerms must be OrderedVocabularies
#6 Updated by Andreas Müller over 2 years ago
- Tags set to additivity
#7 Updated by Andreas Müller over 2 years ago
- Target version changed from CDM UML 5.0 to CDM UML 5.5
#8 Updated by Andreas Müller over 2 years ago
- Related to bug #7340: OderedVocabularies are initialised with DefinedTerms added
#9 Updated by Andreas Müller over 2 years ago
- Description updated (diff)
#10 Updated by Andreas Müller over 2 years ago
- Related to bug #7445: Empty term uri and isoXXX fields should be null added
#11 Updated by Andreas Müller over 2 years ago
- Description updated (diff)
#12 Updated by Andreas Müller over 2 years ago
- Description updated (diff)
#13 Updated by Andreas Müller over 1 year ago
- Target version changed from CDM UML 5.5 to CDM UML 5.15
#14 Updated by Andreas Müller 7 months ago
- Target version changed from CDM UML 5.15 to CDM UML 5.19