feature request #7408
[E+M] Support for preferred common names in data portal
Status:
Feedback
Priority:
Highest
Assignee:
Category:
cdm-dataportal
Target version:
Start date:
05/09/2018
Due date:
% Done:
0%
Estimated time:
6.00 h
Severity:
critical
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 9 months ago
- Blocked by feature request #6945: Allow flagging common names as recommended, synonym or unassessed added
#2 Updated by Andreas Müller 7 months ago
- Target version changed from Release 5.1 to Release 5.2
#3 Updated by Andreas Kohlbecker 5 months ago
- Target version changed from Release 5.2 to Release 5.3
#4 Updated by Andreas Kohlbecker 4 months ago
- Target version changed from Release 5.3 to Release 5.4
#5 Updated by Andreas Müller 4 months ago
This is soon required for E+M
#6 Updated by Andreas Kohlbecker 4 months ago
- Severity changed from normal to major
#7 Updated by Andreas Kohlbecker 3 months ago
- Target version changed from Release 5.4 to Release 5.5
#8 Updated by Andreas Müller 3 months ago
- Severity changed from major to critical
This is critical for Euro+Med Portal release
#9 Updated by Andreas Kohlbecker 3 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 3 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 3 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
