Greetings, I'm slugging through the table relationships trying to figure out how the resource_id in the resourcepolicy table relates to the resource_id in the handle table and the item_id in the metadatavalue table. Currently I'm going through 4 tables (resourcepolicy->bundle2bitstream->item2bundle->handle/metadatavalue)
resource_id.resourcepolicy = bitstream_id.bundle2bitstream bundle_id.bundle2bitstream = bundle_id.item2bundle item_id.item2bundle = item_id.metadatavalue = resource_id.handle Is there an easier way? Any handy sql to pull up handle from resource_id field in the resourcepolicy table would get me a good part of the way there...... I need this as part of a DSpace upgrade where embargo data from the start_date field in resourcepolicy needs to find its way into the metadatavalue table. thanks, Jimmy -- Jimmy Ghaphery Head, Library Information Systems VCU Libraries http://www.library.vcu.edu -- ------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
