Here's the query for DSpace 5: SELECT metadatavalue.text_value, bitstream.*FROM bitstream, metadatavalueWHERE size_bytes = 569AND metadatavalue.resource_type_id = 0AND bitstream.bitstream_id = metadatavalue.resource_idAND metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry mfr, metadataschemaregistry msr WHERE mfr.metadata_schema_id = msr.metadata_schema_id AND short_id = 'dc' AND element = 'title' AND qualifier IS NULL);
Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
