Thank you for this. Would been nice if there was a database lookup table or is there? Lighton Phiri http://lightonphiri.org
On 31 January 2013 02:38, Andrea Schweer <[email protected]> wrote: > Hi, > > On 31/01/13 13:09, Lighton Phiri wrote: >> I am trying to pull out handles for collections I've defined in a >> DSpace instance by joining the handle and collection tables. I am >> expecting to get unique collection details but my query's returning >> duplicates. How do I filter out get this collection information? >> >> Query >> >> SELECT h.handle, c.name >> FROM ((SELECT resource_id, handle FROM handle) as h JOIN >> (SELECT collection_id, name FROM collection) as c ON >> h.resource_id = c.collection_id); > > You need to throw in > WHERE h.resource_type_id = 3 > to get only collections with that ID -- right now you're also getting > the handles for communities and/or items that happen to have the same > numeric ID as your collection. > > The "3" is defined in Constants.jave > (https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/core/Constants.java#L29) > >> Incidentally, I couldn't find a command-line utility to do this or is >> there? > > I'm not aware of a command-line tool for this. > > cheers, > Andrea > > -- > Dr Andrea Schweer > IRR Technical Specialist, ITS Information Systems > The University of Waikato, Hamilton, New Zealand > ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_jan _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
