Project

General

Profile

feature request #7440

E+M mark common name reference with according marker

Added by Andreas Müller almost 3 years ago. Updated 2 months ago.

Status:
Closed
Priority:
Highest
Category:
cdmadapter
Target version:
Start date:
05/28/2018
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 TaxEditor Closed 05/29/2018

Associated revisions

Revision 853106aa (diff)
Added by Andreas Müller over 2 years ago

ref #7440 add common name marker to common name references

Revision a9faed7f (diff)
Added by Katja Luther over 2 years ago

ref #7440: filter common name references only when preference is set

Revision 1e45e654 (diff)
Added by Katja Luther over 2 years ago

ref #7440: filter common name references only when preference is set

History

#1 Updated by Andreas Müller almost 3 years ago

#2 Updated by Andreas Müller over 2 years ago

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

Done. Still needs to be tested.

#3 Updated by Andreas Müller over 2 years ago

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

The markers were imported

#4 Updated by Andreas Müller 3 months ago

#5 Updated by Andreas Müller 3 months ago

#6 Updated by Andreas Müller 2 months 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' 

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)