Re: [Dspace-tech] Question about SQL query
Thanks, helix84! George Kozak Digital Library Specialist Cornell University Library Information Technologies (CUL-IT) 218 Olin Library Cornell University Ithaca, NY 14853 607-255-8924 From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84 Sent: Tuesday, May 12, 2015 10: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 and/or bitstreams are controlled by which groups? It's all in the resourcepolicy table. So for bitstreams: SELECT * FROM resourcepolicy WHERE resource_type_id = '0' and for items (with item handle added): SELECT handle.handle, resourcepolicy.* FROM resourcepolicy, handle WHERE resourcepolicy.resource_type_id = '2' AND resourcepolicy.resource_id = handle.resource_id Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Question about SQL query
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 resource_type_id = '0' and for items (with item handle added): SELECT handle.handle, resourcepolicy.*FROM resourcepolicy, handleWHERE resourcepolicy.resource_type_id = '2'AND resourcepolicy.resource_id = handle.resource_id Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
[Dspace-tech] Question about SQL query
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 Ithaca, NY 14853 607-255-8924 -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette