Project

General

Profile

bug #7763

E+M (post?): Deduplicate "[non ..." blocking names for synonyms

Added by Andreas Müller 6 months ago. Updated 6 months ago.

Status:
New
Priority:
Priority12
Category:
cdmadapter
Target version:
Start date:
09/15/2018
Due date:
% Done:

0%

Severity:
normal
Found in Version:
Tags:

Description

These are handled in BerlinModelTaxonRelationshipImport.handleSynonymNotes

About 150 cases, many of them easy to handle as only the fullname and the year needs to be compared.

Therefore priority higher then #7762


Related issues

Related to Edit - task #7762: E+M: Handle "{non ..." annotations for misapplied names currently handled as appended phrase New 09/15/2018

History

#1 Updated by Andreas Müller 6 months ago

  • Related to task #7762: E+M: Handle "{non ..." annotations for misapplied names currently handled as appended phrase added

#2 Updated by Andreas Müller 6 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;

#3 Updated by Andreas Müller 6 months ago

  • Subject changed from E+M: Deduplicate "[non ..." blocking names for synonyms to E+M (post?): Deduplicate "[non ..." blocking names for synonyms
  • Description updated (diff)

#4 Updated by Andreas Müller 6 months ago

  • Priority changed from Priority13 to Priority12

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)