select * from handle h inner join item i on i.item_id = h.resource_id and h.resource_type_id=2
select * from handle h inner join collection c on c.collection_id = h.resource_id and h.resoruce_type_id=3 Note, the item table has a column owning_collection which is a handy way to get from an item to a collection. Terry On Fri, Nov 4, 2016 at 12:17 PM, Donald Bynum <[email protected]> wrote: > I'm running DSpace 5.5 with XMLUI using Mirage and Oracle as the > database. I am building some custom reports with a combination of SOLR > searches and also queries on the database. Essentially, I am going to get > the list of collection_ids from the COLLECTION table. Then I can query the > COLLECTION2ITEM table to get the list of item_ids for each collection. > What I cannot figure out is how to get the handle value for a > collection/item. Can someone please enlighten me as to how I can get the > handle value for a collection or an item given that I do have the > collection_id and the item_id. > > Regards, > > Don. > > -- > You received this message because you are subscribed to the Google Groups > "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > -- Terry Brady Applications Programmer Analyst Georgetown University Library Information Technology http://georgetown-university-libraries.github.io/ <https://www.library.georgetown.edu/lit/code> 425-298-5498 (Seattle, WA) -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
