Project

General

Profile

bug #6705

Remove remaining orphaned PolytomousKeyNodes

Added by Andreas Müller almost 2 years ago. Updated about 2 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 almost 2 years ago

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

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

  • Description updated (diff)

#3 Updated by Andreas Müller 10 months ago

  • Priority changed from Highest to Priority14

#4 Updated by Andreas Müller 10 months ago

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

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

  • Priority changed from Priority14 to Priority13

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)