Project

General

Profile

bug #9477

New ordered terms do not have correct order index

Added by Andreas Müller 8 months ago. Updated about 9 hours ago.

Status:
Closed
Priority:
Highest
Category:
cdmlib
Target version:
Start date:
02/25/2021
Due date:
% Done:

100%

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+M Closed 02/24/2020
Related to Edit - bug #6343: TermVocabularies of OrderedTerms must be OrderedVocabularies In Progress 01/18/2017
Related to Edit - feature request #9778: Add new rank terms lusus, subgrex and subproles Closed 09/22/2021
Copied to Edit - bug #9784: Update script for term order of ordered CDM terms New 09/23/2021

Associated revisions

Revision 749a2e19 (diff)
Added by Andreas Müller 23 days ago

ref #9477 fix term loading for ordered new terms

History

#1 Updated by Andreas Müller 8 months ago

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

#2 Updated by Andreas Müller 8 months ago

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

#3 Updated by Andreas Müller 23 days ago

  • Description updated (diff)

#4 Updated by Andreas Müller 23 days ago

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

#5 Updated by Andreas Müller 23 days ago

  • Target version changed from CDM UML 5.28 to Release 5.27

#6 Updated by Andreas Müller 23 days ago

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

#7 Updated by Andreas Müller 23 days ago

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

#8 Updated by Andreas Müller 23 days 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

#9 Updated by Andreas Müller 23 days ago

#10 Updated by Andreas Müller 22 days ago

  • Priority changed from New to Highest
  • % Done changed from 50 to 80

#11 Updated by Andreas Müller about 9 hours ago

  • Status changed from Resolved to Closed
  • % Done changed from 80 to 100

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)