Project

General

Profile

Actions

bug #6343

open

TermVocabularies of OrderedTerms must be OrderedVocabularies

Added by Andreas Müller about 5 years ago. Updated 4 months ago.

Status:
In Progress
Priority:
Priority14
Category:
data
Target version:
Start date:
01/18/2017
Due date:
% Done:

0%

Estimated time:
Severity:
normal
Found in Version:
Tags:

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

Related to Edit - bug #7340: OderedVocabularies are initialised with DefinedTerms ClosedAndreas Müller03/29/2018

Actions
Related to Edit - bug #7445: Empty term uri and isoXXX fields should be nullClosedAndreas Müller06/03/2018

Actions
Related to Edit - bug #9477: New ordered terms do not have correct order indexClosedAndreas Müller02/25/2021

Actions
Follows Edit - bug #4821: Changing order of terms not possibleClosedKatja Luther04/29/2015

Actions
Actions #1

Updated by Andreas Müller about 5 years ago

  • Due date set to 04/30/2015
  • Start date changed from 01/18/2017 to 04/30/2015
  • Follows bug #4821: Changing order of terms not possible added
Actions #2

Updated by Andreas Müller about 5 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
Actions #3

Updated by Andreas Müller about 5 years ago

  • Subject changed from TermVocabularies of OrderedTerms must be OrderedVocabulares, Updatescript to TermVocabularies of OrderedTerms must be OrderedVocabulares
Actions #4

Updated by Andreas Müller over 4 years ago

  • Target version changed from CDM UML 4.7 to CDM UML 5.0
Actions #5

Updated by Andreas Müller over 3 years ago

  • Subject changed from TermVocabularies of OrderedTerms must be OrderedVocabulares to TermVocabularies of OrderedTerms must be OrderedVocabularies
Actions #6

Updated by Andreas Müller over 3 years ago

  • Tags set to additivity
Actions #7

Updated by Andreas Müller over 3 years ago

  • Target version changed from CDM UML 5.0 to CDM UML 5.5
Actions #8

Updated by Andreas Müller over 3 years ago

  • Related to bug #7340: OderedVocabularies are initialised with DefinedTerms added
Actions #9

Updated by Andreas Müller over 3 years ago

  • Description updated (diff)
Actions #10

Updated by Andreas Müller over 3 years ago

  • Related to bug #7445: Empty term uri and isoXXX fields should be null added
Actions #11

Updated by Andreas Müller over 3 years ago

  • Description updated (diff)
Actions #12

Updated by Andreas Müller over 3 years ago

  • Description updated (diff)
Actions #13

Updated by Andreas Müller over 2 years ago

  • Target version changed from CDM UML 5.5 to CDM UML 5.15
Actions #14

Updated by Andreas Müller over 1 year ago

  • Target version changed from CDM UML 5.15 to CDM UML 5.29
Actions #15

Updated by Andreas Müller 4 months ago

  • Priority changed from Highest to Priority14
Actions #16

Updated by Andreas Müller 4 months ago

  • Related to bug #9477: New ordered terms do not have correct order index added
Actions

Also available in: Atom PDF