This query will get you started. It will find all items without and anonymous read policy.
select * from item where not exists ( select 1 from resourcepolicy rp where rp.resource_id = item_id and rp.resource_type_id=2 and epersongroup_id=0 and action_id=0 ) You will likely want to refine this query to look at the embargo start/end dates present in the resourcepolicy table. epersongroup_id=0 is anonymous action_id is READ action On Wed, Jan 17, 2018 at 1:35 PM, George Kozak <[email protected]> wrote: > Is there an easy way to find and list all of the collections in DSpace > that have restricted items in them? I thought I could do it in SQL, but > I'm having a hard time coming up with a query that gives me what I want. > BTW: I am using DSpace 5.5. > Thanks! > -- > *************************** > George Kozak > Digital Library Specialist > Cornell University Library - IT > 218 Olin Library > Cornell University > Ithaca, NY 14853 > 607-255-8924 <(607)%20255-8924> > [email protected] > > -- > 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. > -- Terry Brady Applications Programmer Analyst Georgetown University Library Information Technology https://github.com/terrywbrady/info 425-298-5498 (Seattle, WA) -- 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.
