Project

General

Profile

task #7762

E+M: Handle "{non ..." annotations for misapplied names currently handled as appended phrase

Added by Andreas Müller 11 months ago. Updated 3 months ago.

Status:
New
Priority:
Highest
Category:
cdmadapter
Start date:
09/15/2018
Due date:
% Done:

0%

Severity:
normal
Tags:

Description

... check the names against existing names with exactly same reference and replace name if possible, also remove appended phrase.

Only 50 cases so we can also do it manually after import if complicated. Therefore low priority.

Add: There come now 100 more cases from PTaxon.Notes


Related issues

Related to Edit - bug #7763: E+M (post?): Deduplicate "[non ..." blocking names for synonyms New 09/15/2018

History

#1 Updated by Andreas Müller 11 months ago

  • Subject changed from E+M: Handle {non annotations for misapplied names currently handled as appended phrase to E+M: Handle "{non ..." annotations for misapplied names currently handled as appended phrase

#2 Updated by Andreas Müller 11 months ago

  • Related to bug #7763: E+M (post?): Deduplicate "[non ..." blocking names for synonyms added

#3 Updated by Andreas Müller 11 months ago

SELECT n1.FullNameCache,n2.FullNameCache, r.Notes, n1.notes, n2.notes, pt1.notes, r.* 
 FROM RelPTaxon AS r 
       INNER JOIN v_cdm_exp_taxaDirect AS a ON r.PTNameFk2 = a.PTNameFk AND r.PTRefFk2 = a.PTRefFk 
       INNER JOIN PTaxon As pt1 ON pt1.PTNameFk = r.PTNameFk1 AND pt1.PTRefFk = r.PTRefFk1 
       INNER JOIN Name n1 ON n1.NameId = r.PTNameFk1
       INNER JOIN Name n2 ON n2.NameId = r.PTNameFk2
WHERE r.RelPTaxonID NOT IN (1874890,1874959,1874932,1874793,1874956,1874971,1874902,1874696)
   AND NOT (pt1.PTRefFk = 8000000 AND pt1.publishFlag = 0)
   AND r.Notes IS NOT NULL AND r.Notes like '%non %'
ORDER BY r.Notes,PTRefFk1;

#4 Updated by Andreas Müller 11 months ago

  • Description updated (diff)

#5 Updated by Andreas Müller 11 months ago

  • Priority changed from Priority11 to Priority12

#6 Updated by Andreas Müller 3 months ago

  • Priority changed from Priority12 to Highest
  • Target version changed from Euro+Med Migration to Euro+Med post migration

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)