Project

General

Profile

Actions

bug #9477

closed

New ordered terms do not have correct order index

Added by Andreas Müller over 1 year ago. Updated 12 months ago.

Status:
Closed
Priority:
Highest
Category:
cdmlib
Target version:
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 #1

Updated by Andreas Müller over 1 year ago

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

Updated by Andreas Müller over 1 year ago

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

Updated by Andreas Müller about 1 year ago

  • Description updated (diff)
Actions #4

Updated by Andreas Müller about 1 year ago

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

Updated by Andreas Müller about 1 year ago

  • Target version changed from CDM UML 5.34 to Release 5.27
Actions #6

Updated by Andreas Müller about 1 year ago

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

Updated by Andreas Müller about 1 year ago

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

Updated by Andreas Müller about 1 year 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 #9

Updated by Andreas Müller about 1 year ago

Actions #10

Updated by Andreas Müller about 1 year ago

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

Updated by Andreas Müller 12 months ago

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

Updated by Andreas Müller 11 months ago

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

Also available in: Atom PDF