Hi all,
My library recently discovered a few bitstreams where the primary document has multiple entries. The top entry requires the university affiliated group to sign in but the second one is open to all. So the document is open to everyone despite the intention that users must logon first. If possible I want to write a query to find all the items that have this issue. I have tried a few things to find duplicate bitstream items that have not worked. select text_value from metadatavalue where (select count(*) from bitstream, bundle, bundle2bitstream, item2bundle where bundle.uuid = bundle2bitstream.bundle_id AND bundle2bitstream.bitstream_id = bitstream.uuid AND item2bundle.bundle_id = bundle.uuid) > 1 AND metadata_field_id = 25 order by text_value Nick Crimi Joyner Library East Carolina University -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.