Hi Helix
Thanks for the SQL. I am afraid I don’t have access to run SQL queries on our
server ☹
I will see what I can get around here.
Rodrigo
From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84
Sent: Sunday, December 02, 2012 6:39 AM
To: Calloni, Rodrigo
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] How does DSpace stores the data from Authority
Controled fields
On Sat, Dec 1, 2012 at 12:25 AM, Calloni, Rodrigo
<rcall...@iadb.org<mailto:rcall...@iadb.org>> wrote:
> I believe that DSpace will record AG-AGR in the database instead of
> “Agricultura y seguridad alimentaria”. Is this correct?
I'm not sure, but why don't you take a look?
SELECT * FROM "metadatavalue"
WHERE "metadata_field_id" =
(SELECT "metadata_field_id" FROM "metadatafieldregistry" WHERE "element" =
'contributor' AND "qualifier" = 'author' LIMIT 1)
LIMIT 30
Replace element and qualifier values with the DC fields you want. You will see
a list of the values for the first 30 items. The text_value column stores the
metadata value.
Regards,
~~helix84
Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
Keep yourself connected to Go Parallel:
BUILD Helping you discover the best ways to construct your parallel projects.
http://goparallel.sourceforge.net
_______________________________________________
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