That worked like a charm, helix84!
Is it possible to make groups with the CLI, similar to the «user» command for
creating users, or in any other way script this behavior?
--
Vegard
From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84
Sent: Thursday, May 21, 2015 12:57 PM
To: Vegard Korvald
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] eperson and groups
On Thu, May 21, 2015 at 12:22 PM, Vegard Korvald
<vegard.korv...@usit.uio.no<mailto:vegard.korv...@usit.uio.no>> wrote:
I used "SELECT * FROM epersongroup " to get the IDs, but I couldn't seem to
find the corresponding group name in the database. To find the name I had to
look it up as an admin on our DSpace page under Access Control->Groups. Is
there a way to find the IDs and names of the groups in the database?
Sorry about that, I forgot to note that since DSpace 5, the epersongroup table
changed due to the "metadata for all dspace objects" feature. You can get the
same view on the table as in previous versions using this query instead (6 is
the constant for group):
SELECT e.*, m.text_value AS name FROM epersongroup e
LEFT JOIN metadatavalue m ON (
m.resource_id = e.eperson_group_id
AND m.resource_type_id = 6
)
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