On 13 May 2013 20:27, Thornton, Susan M. (LARC-B702)[LITES] <
[email protected]> wrote:
> You will have to join the Item table to the metadatavalue table where
> metadata_field_id = 99 (where 99 = date.accessioned). Do your date
> specification on date.accessioned since that’s the date/timestamp the Item
> was added to the repository.
In my case the necessary metadata_field_id seems to be 11, so the following
gets me started:
SELECT i.item_id, i.owning_collection, text_value FROM metadatavalue m,
item i WHERE m.item_id = i.item_id AND m.metadata_field_id = 11;
Thank you, Sue and Wilko!
Sean
--
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
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
