Actions
feature request #7440
closedE+M mark common name reference with according marker
Status:
Closed
Priority:
Highest
Assignee:
Category:
cdmadapter
Target version:
Start date:
Due date:
% Done:
100%
Estimated time:
2:00 h
Severity:
major
Related issues
Updated by Andreas Müller about 6 years ago
- Blocks feature request #7345: [E+M] Common name references selectable in TaxEditor added
Updated by Andreas Müller almost 6 years ago
- Status changed from New to In Progress
- % Done changed from 0 to 70
Done. Still needs to be tested.
Updated by Andreas Müller almost 6 years ago
- Status changed from In Progress to Resolved
- % Done changed from 70 to 90
The markers were imported
Updated by Andreas Müller over 3 years ago
- Blocks deleted (feature request #7345: [E+M] Common name references selectable in TaxEditor)
Updated by Andreas Müller over 3 years ago
- Precedes feature request #7345: [E+M] Common name references selectable in TaxEditor added
Updated by Andreas Müller over 3 years ago
- Status changed from Resolved to Closed
- % Done changed from 90 to 100
I checked the final import result and it looks ok.
SELECT r.id, r.uuid, r.titleCache, m.flag, mt.titleCache, mt.id FROM Reference r INNER JOIN Reference_Marker MN ON MN.Reference_id = r.id INNER JOIN Marker m ON m.id = MN.markers_id INNER JOIN DefinedTermBase mt ON mt.id = m.markerType_id WHERE mt.id = 965 ; SELECT DISTINCT osb.citation_id -- SELECT deb.id, MN.*, osb.id, feature.id, osb.citation_id, osb.sourceType FROM DescriptionElementBase deb INNER JOIN DescriptionElementBase_OriginalSourceBase MN ON MN.DescriptionElementBase_id = deb.id INNER JOIN OriginalSourceBase osb ON osb.id = MN.sources_id INNER JOIN DefinedTermBase feature ON deb.feature_id = feature.id WHERE feature.id = 991 AND osb.sourceType <> 'DIM'
Actions