« mime types in AgEcon | Main | Documentation of php code to query DSPACE DB »

DSPACE sql for items that have not been withdrawn

The line below will do a search for dc.type (metadata_field_id=66) for items that have not been withdrawn.
select handle from handle, metadatavalue, item where metadata_field_id=66 AND metadatavalue.item_id=handle.resource_id AND text_value='Other' AND resource_id=item.item_id AND 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.)