« DSPACE performance problem traced to file of indices missing | Main | rels-ext for collections »

SQL: extracting the purl and title from dspace given a handle

dspace_sr=> select text_value from metadatavalue, handle where metadata_field_id=25 AND item_id=handle.resource_id and handle=49928;

text_value
---------------------------
http://purl.umn.edu/49928
dspace_sr=> select text_value from metadatavalue, handle where metadata_field_id=64 AND item_id=handle.resource_id and handle=49928;

text_value
-------------------------------------------------------------------------------------------
Food-safety Standards and Farmers Health: Evidence from Kenyan’s Export Vegetable Growers

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.)