On Thu, May 21, 2015 at 12:22 PM, Vegard Korvald <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 eLEFT 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
