Issue 14402
Country information missing from contacts information
14402
Reporter: anmnielsen
Type: Bug
Summary: Country information missing from contacts information
Priority: Blocker
Resolution: Fixed
Status: Closed
Created: 2013-11-22 12:57:04.826
Updated: 2014-03-26 11:59:27.184
Resolved: 2014-03-26 11:59:27.154
Description: If you click on a person in the contacts list on http://www.gbif.org/contact/directoryofcontacts you get the contact information - but no country information. Could you please add that?
Thank you.
Best,
Anne Mette]]>
Author: kbraak@gbif.org
Comment: Thanks for reporting the issue [~anmnielsen].
Created: 2013-11-22 15:42:17.157
Updated: 2013-11-22 15:42:17.157
Author: trobertson@gbif.org
Created: 2014-03-17 16:58:24.263
Updated: 2014-03-17 16:58:24.263
The following JOIN makes this possible:
{code:sql}
SELECT
c.Name_First as firstName,
c.Name_Last as lastName,
a.Name as country
FROM
gbifims_Contact c JOIN gbifims_Country a ON c .CountryID_Address = a.CountryID
{code}