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?
Incidentally, I couldn't find a command-line utility to do this or is
there?
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);
Result
handle | name
---------------+------------------
123456789/1 | ADTP
123456789/114 | ADTP
123456789/2 | ADTP
123456789/3 | AUCKLAND
Lighton Phiri
http://lightonphiri.org
------------------------------------------------------------------------------
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
