« Pulling handles and bitstreams from dspace & Handles with no bitstreams | Main | crawler not working for UDC »

sql to pull relation metadata

select text_value from metadatavalue, handle where metadata_field_id=40 AND item_id=handle.resource_id AND handle.resource_type_id=2 AND handle.resource_id=item.item_id AND item.withdrawn='f';

Posted by Jeffrey Silvis on April 26, 2011 7:52 PM |

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)