On Mon, Oct 26, 2015 at 4:44 PM, Margaret Vail <margaret.v...@gmail.com> wrote: > Is there a way to currently view all embargoed items in DSpace 5.x?
Assuming you're using the newer DSpace 3-style embargo. I don't think that you can do that in either UI. Here's a SQL query that will give you item handles for all bitstreams which have a policy with either a specified start date or end date: SELECT h.handle, rp.*FROM resourcepolicy rp, bundle2bitstream b2b, item2bundle i2b, handle hWHERE (start_date IS NOT NULL OR end_date IS NOT NULL)AND rp.resource_type_id = 0AND b2b.bitstream_id = rp.resource_idAND i2b.bundle_id = b2b.bundle_idAND i2b.item_id = h.resource_idAND h.resource_type_id = 2; 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at http://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
