Project

General

Profile

feature request #7408

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

Added by Andreas Müller 9 months ago. Updated 3 months ago.

Status:
Feedback
Priority:
Highest
Category:
cdm-dataportal
Target version:
Start date:
05/09/2018
Due date:
% Done:

0%

Estimated time:
6.00 h
Severity:
critical
Tags:

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

Blocked by Edit - feature request #6945: Allow flagging common names as recommended, synonym or unassessed Resolved 09/13/2017

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.

#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 

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)