Actions
task #7762
openE+M: Handle "{non ..." annotations for misapplied names currently handled as appended phrase
Status:
New
Priority:
Highest
Assignee:
Category:
cdmadapter
Target version:
Start date:
Due date:
% Done:
0%
Estimated time:
Severity:
normal
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
Updated by Andreas Müller over 5 years 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
Updated by Andreas Müller over 5 years ago
- Related to bug #7763: E+M (post?): Deduplicate "[non ..." blocking names for synonyms added
Updated by Andreas Müller over 5 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;
Updated by Andreas Müller over 5 years ago
- Priority changed from Priority11 to Priority12
Updated by Andreas Müller almost 5 years ago
- Priority changed from Priority12 to Highest
- Target version changed from Euro+Med Migration to Euro+Med post migration
Actions