bug #7763
E+M (post?): Deduplicate "[non ..." blocking names for synonyms
Status:
New
Priority:
Highest
Assignee:
Category:
cdmadapter
Target version:
Start date:
09/15/2018
Due date:
% Done:
0%
Severity:
normal
Found in Version:
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
History
#1 Updated by Andreas Müller over 2 years 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 over 2 years 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 over 2 years 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 over 2 years ago
- Priority changed from Priority13 to Priority12
#5 Updated by Andreas Müller almost 2 years ago
- Priority changed from Priority12 to Highest
- Target version changed from Euro+Med Migration to Euro+Med post migration