Actions
task #8734
closedUpdate distributions from TDWG-L4 to TDWG-L3 where L4=L3
Start date:
Due date:
% Done:
100%
Estimated time:
Severity:
normal
Description
This will shorten the textuell representations of distribution data in the data portal
Updated by Andreas Müller over 4 years ago
- Status changed from New to In Progress
- Priority changed from New to Highest
SQL to use
UPDATE DescriptionElementBase deb INNER JOIN DefinedTermBase a ON deb.area_id = a.id INNER JOIN DefinedTermBase pa ON pa.id = a.partof_id SET area_id = pa.id WHERE a.idInVocabulary LIKE '%-OO'
and for _AUD
UPDATE DescriptionElementBase_AUD deb INNER JOIN DefinedTermBase a ON deb.area_id = a.id INNER JOIN DefinedTermBase pa ON pa.id = a.partof_id SET area_id = pa.id WHERE a.idInVocabulary LIKE '%-OO'
but will run only on MySQL
Updated by Andreas Müller over 4 years ago
- Status changed from In Progress to Closed
- Target version deleted (
Release 5.12) - % Done changed from 0 to 100
Actions