Project

General

Profile

bug #6705

Remove remaining orphaned PolytomousKeyNodes

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

Status:
New
Priority:
Priority13
Category:
data
Target version:
Start date:
06/08/2017
Due date:
% Done:

0%

Severity:
normal
Found in Version:

Description

There are PKN left that are linked to an existing key but have no parent but link to a taxon (so are no root nodes).

SELECT *
FROM PolytomousKeyNode pkn
WHERE pkn.parent_id IS NULL
AND pkn.taxon_id IS NOT NULL

Check carefully that they are not linked as parents and that they are not root nodes. Maybe run recursively until none is left.

Also use the script used in #6226 to remove orphaned KeyStatements afterwards.

There are 16 examples in cyprus.


Related issues

Copied from Edit - task #6226: Delete orphaned key nodes Closed 11/28/2016

History

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

  • Copied from task #6226: Delete orphaned key nodes added

#2 Updated by Andreas Müller about 2 years ago

  • Description updated (diff)

#3 Updated by Andreas Müller over 1 year ago

  • Priority changed from Highest to Priority14

#4 Updated by Andreas Müller over 1 year ago

  • Target version changed from CDM UML 5.0 to CDM UML 5.5

#5 Updated by Andreas Müller 7 months ago

  • Priority changed from Priority14 to Priority13

#6 Updated by Andreas Müller 4 months ago

  • Target version changed from CDM UML 5.5 to CDM UML 5.10

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)