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
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
--
---
El software de antivirus Avast ha analizado este correo electrónico en busca de
virus.
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
