Thanks, helix84 - this will give me something to chew on. When I run,
select * from metadatavalue where metadata_field_id = '24' and text_value
LIKE '1967%'
I can see all the pdf files from 1967. Given the item_id from that query,
how do I find the handle?
Thanks again -
Mark
On Tue, Jun 5, 2012 at 12:33 PM, helix84 <[email protected]> wrote:
> On Tue, Jun 5, 2012 at 6:13 PM, Mark Ehle <[email protected]> wrote:
> > capable with mysql. Can someone tell me what the query would be to
> extract
> > from dspace all the item names, their handles. and the bitstream
> associated
> > with each one?
>
> Hi Mark,
>
> here's the DSpace database schema:
>
> https://wiki.duraspace.org/display/DSPACE/DSpace+2.0+Requirements+and+Issues#DSpace2.0RequirementsandIssues-DatabaseOverviewGraphic
>
> item name is stored in the "metadatavalue" table (by default " WHERE
> metadata_field_id=64", you can look up the value in
> "metadatafieldregistry"), handle in "handle" (resource_id is item ID)
> and bistream in "bitstream" connected to items via bundle2bitstream
> and item2bundle. The queries can get a bit hairy, since metadatavalue
> is an EAV table, but it is doable. Let me know if you have any
> problems.
>
> Regards,
> ~~helix84
>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
