Project

General

Profile

Actions

feature request #7440

closed

E+M mark common name reference with according marker

Added by Andreas Müller over 4 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Highest
Category:
cdmadapter
Target version:
Start date:
Due date:
% Done:

100%

Estimated time:
2:00 h
Severity:
major
Tags:

Description

for further info see #7345


Related issues

Precedes EDIT - feature request #7345: [E+M] Common name references selectable in TaxEditorClosedKatja Luther

Actions
Actions #1

Updated by Andreas Müller over 4 years ago

Actions #2

Updated by Andreas Müller over 4 years ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 70

Done. Still needs to be tested.

Actions #3

Updated by Andreas Müller over 4 years ago

  • Status changed from In Progress to Resolved
  • % Done changed from 70 to 90

The markers were imported

Actions #4

Updated by Andreas Müller about 2 years ago

Actions #5

Updated by Andreas Müller about 2 years ago

Actions #6

Updated by Andreas Müller about 2 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

Also available in: Atom PDF