Project

General

Profile

bug #9322

Remove invalid designation taxon relationship

Added by Andreas Müller about 2 months ago. Updated about 1 month ago.

Status:
Closed
Priority:
Priority14
Category:
cdmlib
Target version:
Start date:
11/25/2020
Due date:
% Done:

100%

Severity:
normal
Found in Version:

Description

Invalid designations are simply names which are not valid and therefore are called "designations" only not "names".

For some reason in the Berlin Model there was a taxon relationship called "is invalid designation for" which was imported to CDM as well.

This relationship should not be used. Instead a synonym relationship should be used and the "designation" name should get a nomenclatural status indicating that it is "invalid".

Therefore everything related to "invalid designation" relationship should be deleted in TaxEditor, Dataportal and cdmlib/model.


Related issues

Related to Edit - task #8055: Correct formatting for invalid designations Rejected 02/01/2019
Related to Edit - feature request #7761: Invalid designations should be displayed like misapplied names in name editor Closed 09/14/2018
Related to Edit - feature request #6394: Allow additional taxon relationships in TaxEditor to be handled similar to misapplications New 01/27/2017

Associated revisions

Revision 180653b7 (diff)
Added by Katja Luther about 2 months ago

remove create/change to invalid designation handler

Revision 1ffd1c27 (diff)
Added by Andreas Müller about 2 months ago

ref #9322 remove invalid designation relationship from cdmlib

Revision 11358be4 (diff)
Added by Andreas Müller about 2 months ago

ref #9322 adapt TaxEditor to removed invalid designation relationship

Revision 8cf3ca0a (diff)
Added by Andreas Müller about 2 months ago

ref #9322 adapt vaadin to removed invalid designation relationship

Revision adbd3997 (diff)
Added by Andreas Müller about 2 months ago

ref #9322 adapt TaxEditor to removed invalid designation relationship (cont.)

Revision a647b46a (diff)
Added by Andreas Müller about 2 months ago

ref #9322 adapt TaxEditor to removed invalid designation relationship (cont. 2)

Revision 7f5fe60c (diff)
Added by Andreas Müller about 2 months ago

ref #9322 adapt TaxEditor to removed invalid designation relationship (cont. 3)

Revision 82fc7e6e (diff)
Added by Andreas Müller about 2 months ago

ref #9322 adapt BerlinModelOccurrenceSourceImport to removed Invalid Designation

Revision 0b429510 (diff)
Added by Andreas Kohlbecker about 1 month ago

ref #9322 removing taxon relationship invalid designation from portal code

Revision e2d8dde3 (diff)
Added by Andreas Müller about 1 month ago

ref #9322 handle also AUD table in SingleTermRemover and connect the schema updater

Revision 68aa76e0 (diff)
Added by Andreas Kohlbecker about 1 month ago

ref #9322 changing test case for invalid designation to misapplied name

History

#1 Updated by Andreas Müller about 2 months ago

  • Related to task #8055: Correct formatting for invalid designations added

#3 Updated by Andreas Müller about 2 months ago

  • Related to feature request #7761: Invalid designations should be displayed like misapplied names in name editor added

#4 Updated by Andreas Müller about 2 months ago

  • Related to feature request #6394: Allow additional taxon relationships in TaxEditor to be handled similar to misapplications added

#5 Updated by Andreas Müller about 2 months ago

Find possible cases:

SELECT tr.id, tb1.titleCache fromx , tb2.titleCache tox, tr.*
FROM TaxonRelationship tr 
INNER JOIN DefinedTermBase trType ON trType.id = tr.type_id 
LEFT JOIN TaxonBase tb2 ON tb2.id = tr.relatedto_id
LEFT JOIN TaxonBase tb1 ON tb1.id = tr.relatedfrom_id
WHERE trType.uuid = '605b1d01-f2b1-4544-b2e0-6f08def3d6ed'

;

SELECT tr.id, tb1.titleCache fromx , tb2.titleCache tox, tr.*
FROM TaxonRelationship_AUD tr 
INNER JOIN DefinedTermBase trType ON trType.id = tr.type_id 
LEFT JOIN TaxonBase tb2 ON tb2.id = tr.relatedto_id
LEFT JOIN TaxonBase tb1 ON tb1.id = tr.relatedfrom_id
WHERE trType.uuid = '605b1d01-f2b1-4544-b2e0-6f08def3d6ed';

SELECT *
FROM TaxonRelationship_AUD tr 
WHERE tr.id IN (
SELECT tr.id
FROM TaxonRelationship_AUD tr 
INNER JOIN DefinedTermBase trType ON trType.id = tr.type_id 
LEFT JOIN TaxonBase tb2 ON tb2.id = tr.relatedto_id
LEFT JOIN TaxonBase tb1 ON tb1.id = tr.relatedfrom_id
WHERE trType.uuid = '605b1d01-f2b1-4544-b2e0-6f08def3d6ed'
)

#6 Updated by Andreas Müller about 2 months ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 50

This is generally fixed. Only in integration_reference there is still 1 record left (mail sent to AK).

After release run query again on all production to be on the save side.

#7 Updated by Andreas Müller about 2 months ago

  • Priority changed from New to Priority14

#8 Updated by Andreas Müller about 1 month ago

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

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)