Pull community name and collection name from postgres DB

[Kim, Joshua]

Hello,

We have a long list of items which need to show a hierarchy (under which community name and collection name). How can I pull the data by using  Postgres DB? I am looking at the DB schema, but I am confused. Or the other way? Can anyone help me out with this?

Joshua Kim Library, Museums and Press jos...@udel.edu

[DSpace Technical Support]

Hi Joshua,

Items can belong to several Collections, so there may not always be a single hierarchy.  But each Item will have an "owning collection".  If you are using DSpace 7, you can get this information from the REST API itself:

* Get "owning collection" for an Item: https://github.com/DSpace/RestContract/blob/dspace-7_x/items.md#owning-collection

* Get parent community for Collection: https://github.com/DSpace/RestContract/blob/dspace-7_x/collections.md#parent-community

That's the easiest way to gather this information.  It's also possible to use the database, but it'd be a complex query.  You'd need to look closer at the "collection2item" (maps collections to items) and "community2collection" and "community2community" tables, as those contain the hierarchy between these objects.

Tim