feature request #7408: [E+M] Support for preferred common names in data portal - Edit - Redmine

feature request #7408

[E+M] Support for preferred common names in data portal

Added by Andreas Müller about 1 year ago. Updated 16 days ago.

Status:

New

Priority:

Highest

Assignee:

Andreas Kohlbecker

Category:

cdm-dataportal

Target version:

Release 5.8

Start date:

05/09/2018

Due date:

% Done:

Estimated time:

6.00 h

Severity:

critical

Tags:

euro+med

Description

In the current BM portal the preferred common names are in bold (e.g. http://ww2.bgbm.org/EuroPlusMed/PTaxonDetail.asp?NameCache=Bellis%20perennis&PTRefFk=7000000). We need something similar in CDM data portal.

see #6945

Related issues

History

#1 Updated by Andreas Müller about 1 year ago

Blocked by feature request #6945: Allow flagging common names as recommended, synonym or unassessed added

#2 Updated by Andreas Müller 11 months ago

Target version changed from Release 5.1 to Release 5.2

#3 Updated by Andreas Kohlbecker 9 months ago

Target version changed from Release 5.2 to Release 5.3

#4 Updated by Andreas Kohlbecker 8 months ago

Target version changed from Release 5.3 to Release 5.4

#5 Updated by Andreas Müller 8 months ago

This is soon required for E+M

#6 Updated by Andreas Kohlbecker 8 months ago

Severity changed from normal to major

#7 Updated by Andreas Kohlbecker 7 months ago

Target version changed from Release 5.4 to Release 5.5

#8 Updated by Andreas Müller 7 months ago

Severity changed from major to critical

This is critical for Euro+Med Portal release

#9 Updated by Andreas Kohlbecker 7 months ago

Status changed from New to Feedback
Assignee changed from Andreas Kohlbecker to Andreas Müller

Please provide an example dataset.

#10 Updated by Andreas Müller 7 months ago

Campanula trachelium (http://test.e-taxonomy.eu/dataportal/preview/euromed/cdm_dataportal/taxon/ec389413-4102-43bc-95e0-784719d7df7a or http://portal.cybertaxonomy.org/euromed/cdm_dataportal/taxon/ec389413-4102-43bc-95e0-784719d7df7a) is an example where you find all 3 types.

#11 Updated by Andreas Müller 7 months ago

SELECT DISTINCT tb.id, tb.uuid, tb.titleCache, m.markerType_id
FROM DescriptionElementBase deb INNER JOIN DescriptionBase db ON db.id = deb.inDescription_id
INNER JOIN TaxonBase tb ON db.taxon_id = tb.id
LEFT  JOIN DescriptionElementBase_Marker MN ON MN.DescriptionElementBase_id = deb.id 
LEFT JOIN Marker m ON MN.markers_id = m.id
WHERE deb.DTYPE like 'CommonTaxonName'
ORDER BY tb.id
LIMIT 1000