Hi, Matt, while the schema diagram found in the documentation implies that there's a field in each table for handle[1], the handle table actually holds all the data you seek. The column RESOURCE_TYPE_ID indicates what sort of thing the handle points to (2=item, 3=collection, 4=community [2]) and RESOURCE_ID is the ID of the object in question. So, SELECT HANDLE,RESOURCE_ID FROM HANDLE WHERE RESOURCE_TYPE_ID=4 would get you the matrix of handle to community IDs, similarly, SELECT HANDLE,RESOURCE_ID FROM HANDLE WHERE RESOURCE_TYPE_ID=3 would get you the matrix of handle to collection Ids, and so on.
[1] https://wiki.duraspace.org/display/DSDOC3x/Functional+Overview [2] https://wiki.duraspace.org/display/DSDOC3x/Business+Logic+Layer#BusinessLog icLayer-Constants -- HARDY POTTINGER <pottinge...@umsystem.edu> University of Missouri Library Systems http://lso.umsystem.edu/~pottingerhj/ https://MOspace.umsystem.edu/ "No matter how far down the wrong road you've gone, turn back." --Turkish proverb On 3/12/13 11:45 AM, "Drover, Matt" <mattdro...@mun.ca> wrote: >How do I get the handle for communities and collections, providing I have >the community_id or collection_id ? I'm not seeing a table or field that >links the two in the database. > >Thanks. > >Matthew Drover >Programmer Consultant >Immersive Technology >Distance Education, Learning and Teaching Support > >Memorial University of Newfoundland > > > > > >This electronic communication is governed by the terms and conditions at >http://www.mun.ca/cc/policies/electronic_communications_disclaimer_2012.ph >p > > ------------------------------------------------------------------------------ Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev _______________________________________________ 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