And - this query duplicates what's in the map files:
SELECT text_value, handle FROM metadatavalue INNER JOIN handle ON
(metadatavalue.item_id = handle.resource_id) where metadata_field_id = '24'
Thanks!
Mark
On Tue, Jun 5, 2012 at 2:28 PM, helix84 <[email protected]> wrote:
> On Tue, Jun 5, 2012 at 7:50 PM, Mark Ehle <[email protected]> wrote:
> > 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?
>
> Easy - for item_id=123:
>
> SELECT handle FROM handle WHERE resource_id = 123;
>
> 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
