On Thu, May 07, 2015 at 02:09:57PM +0200, Fernando Gómez Romero wrote: > I've just upgrade my DSpace version recently from v4.3 to 5.1. I > developed external statistics with some database queries asking for the > group and eperson names. In the v4 schema this was very handy, in tables > epersongroup.name or eperson.firstname/eperson.lastname . > > But in the 5.1 schema I have seen that these name and lastname values > are gone, with some other more. Where can I get that info? It has to be > somewhere because DSpace uses it, but I want to get it for my external > info.
These moved into the metadatavalue table in 5.0. Use eperson_id as the resource_id, org.dspace.core.Constants.EPERSON or .GROUP as resource_type_id, and (SELECT metadata_field_id FROM metadatafieldregistry WHERE metadata_schema_id = (SELECT metadata_schema_id FROM metadataschemaregistry WHERE namespace = 'http://dspace.org/eperson') AND element = 'firstname') [for example] as metadata_field_id. -- Mark H. Wood Lead Technology Analyst University Library Indiana University - Purdue University Indianapolis 755 W. Michigan Street Indianapolis, IN 46202 317-274-0749 www.ulib.iupui.edu
signature.asc
Description: Digital signature
------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
