subject:"\[Dspace\-tech\] Question about SQL query"

Re: [Dspace-tech] Question about SQL query

2015-05-12 Thread George Stanley Kozak

:44 AM To: George Stanley Kozak Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Question about SQL query On Tue, May 12, 2015 at 4:23 PM, George Stanley Kozak mailto:g...@cornell.edu>> wrote: Is there a PostGreSQL query that can be run (DSpace 5.1) to find which items

Re: [Dspace-tech] Question about SQL query

2015-05-12 Thread helix84

On Tue, May 12, 2015 at 4:23 PM, George Stanley Kozak wrote: > Is there a PostGreSQL query that can be run (DSpace 5.1) to find which > items and/or bitstreams are controlled by which groups? > > It's all in the resourcepolicy table. So for bitstreams: SELECT * FROM resourcepolicy WHERE resour

[Dspace-tech] Question about SQL query

2015-05-12 Thread George Stanley Kozak

Hi, Everyone: Is there a PostGreSQL query that can be run (DSpace 5.1) to find which items and/or bitstreams are controlled by which groups? Thanks in advance. George Kozak Digital Library Specialist Cornell University Library Information Technologies (CUL-IT) 218 Olin Library Cornell University