Project

General

Profile

Actions
Copy link

bug #9477

closed

New ordered terms do not have correct order index

Added by Andreas Müller almost 3 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Highest
Assignee:
Andreas Müller
Category:
cdmlib
Target version:
Release 5.27
Start date:
Due date:
% Done:

100%

Estimated time:
Severity:
normal
Found in Version:

Description

If a new term is added to a new ordered term vocabulary the term is not put to the correct position. Instead it is moved to the end but has the same orderindex as the currently last term.

An example are PresenceAbsenceTerms 

SELECT dtb.id, dtb.uuid, dtb.titleCache, dtb.orderIndex, voc.uuid, voc.id, voc.titleCache
FROM DefinedTermBase dtb INNER JOIN TermCollection voc ON voc.id = dtb.vocabulary_id
WHERE voc.uuid = 'adbbbe15-c4d3-47b7-80a8-c7d104e53a05'
ORDER BY dtb.orderIndex

We need an update script for all terms that were added this way. => #9784
Also the term loader needs to be fixed to avoid this bug for new terms.

Related issues

Related to EDIT - bug #8858: Ordering of distribution status 'undefined' is not correct in E+MClosedAndreas Müller

Actions
Related to EDIT - bug #6343: TermVocabularies of OrderedTerms must be OrderedVocabulariesIn ProgressAndreas Müller

Actions
Related to EDIT - feature request #9778: Add new rank terms lusus, subgrex and subprolesClosedAndreas Müller

Actions
Related to EDIT - bug #9831: Exception in TermRepresentationUpdater if term does not existClosedAndreas Müller

Actions
Copied to EDIT - bug #9784: Update script for term order of ordered CDM termsNewAndreas Müller

Actions
Actions
Copy link
 #1

Updated by Andreas Müller almost 3 years ago

  • Related to bug #8858: Ordering of distribution status 'undefined' is not correct in E+M added
Actions
Copy link
 #2

Updated by Andreas Müller almost 3 years ago

  • Related to feature request #9500: Allow removing certain distribution status from distribution publication added
Actions
Copy link
 #3

Updated by Andreas Müller about 2 years ago

  • Description updated (diff)
Actions
Copy link
 #4

Updated by Andreas Müller about 2 years ago

  • Related to bug #6343: TermVocabularies of OrderedTerms must be OrderedVocabularies added
Actions
Copy link
 #5

Updated by Andreas Müller about 2 years ago

  • Target version changed from CDM UML 5.42 to Release 5.27
Actions
Copy link
 #6

Updated by Andreas Müller about 2 years ago

  • Related to deleted (feature request #9500: Allow removing certain distribution status from distribution publication)
Actions
Copy link
 #7

Updated by Andreas Müller about 2 years ago

  • Copied to bug #9784: Update script for term order of ordered CDM terms added
Actions
Copy link
 #8

Updated by Andreas Müller about 2 years ago

  • Description updated (diff)
  • Status changed from New to Resolved
  • % Done changed from 0 to 50

before closing check on production if it worked correctly. I already tested locally.

SELECT id, dtb.orderIndex, dtb.titleCache
FROM DefinedTermBase dtb
WHERE dtb.DTYPE = 'Rank'
ORDER BY dtb.orderIndex
Actions
Copy link
 #9

Updated by Andreas Müller about 2 years ago

Actions
Copy link
 #10

Updated by Andreas Müller about 2 years ago

  • Priority changed from New to Highest
  • % Done changed from 50 to 80
Actions
Copy link
 #11

Updated by Andreas Müller about 2 years ago

  • Status changed from Resolved to Closed
  • % Done changed from 80 to 100
Actions
Copy link
 #12

Updated by Andreas Müller about 2 years ago

  • Related to bug #9831: Exception in TermRepresentationUpdater if term does not exist added
Actions
Copy link

Also available in: Atom PDF