« Documentation of php code to query DSPACE DB | Main | AgEcon handle 93411 messed up ... reingest »

SQL to find handles that correspond to a specific language.iso in DSPACE

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

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