Thank you, Adan!
George Kozak
Digital Library Specialist
Cornell University Library Information Technologies (CUL-IT)
218 Olin Library
Cornell University
Ithaca, NY 14853
607-255-8924
From: Adan Roman [mailto:aro...@arvo.es]
Sent: Monday, November 17, 2014 11:00 AM
To: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] An SQL question
Hi George
The tables you need are metadatavalue, that contains all the metadatavalues ot
the items and metadatafieldregistry, that hold the type of each metadata.
You can join this author_id whith the metadata values.
try:
select * from metadatafieldregistry mfr, metadatavalue mv
where mfr.element='contributor' and
mfr.qualifier='author' and
mv.metadata_field_id=mfr.metadata_field_id and
mv.item_id=$item_id
that gives you all the contributor.author of an item.
I hope this help
[cid:image001.jpg@01D00256.37A15F70]
Hi...
I have a question for anyone who is familiar with the PostgreSQL tables for
DSpace. This is for DSpace 1.8.2.
I have a script that runs a series of SQL queries and generates reports at our
site. In the reports, I list monthly downloads with the title of the item and
the author(s). It turns out that in my reports, I am listing all the
contributors for an item as the authors of the item. and I've been asked to
just list contributor.author, only.
To get the authors, I do the following:
select distinct_id from bi_2_dmap where item_id=$item_id;
then
select value from bi_2_dis where id=$author_id; (where $author_id =
distinct_id)
I had assumed that these tables held just "contributor.author", but it appears
that they hold all contributors. Is there somewhere in SQL where the different
types of contributors are identified?
My thanks in advance.
George Kozak
Digital Library Specialist
Cornell University Library Information Technologies (CUL-IT)
218 Olin Library
Cornell University
Ithaca, NY 14853
607-255-8924
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net<mailto:DSpace-tech@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
--
________________________________
[http://static.avast.com/emails/avast-mail-stamp.png]<http://www.avast.com/>
El software de antivirus Avast ha analizado este correo electrónico en busca de
virus.
www.avast.com<http://www.avast.com/>
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
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