Hi, I want to extract details of the Collections in my DSpace 6 DEV system so was just looking in the database (postgres) but can't seem to find what I'm looking for, so I'm hoping someone might be able to shed some light . . . ?
In DSpace v4 I was able to pull the information I wanted from the table "collections" (i.e. id, "name", "short description", "introductory text", etc) . . . However, in DSpace v6, the "collection" table has fewer columns, and is missing all the "textual detail" relating to each Collection (so no "name", "short_description" etc) . . . I've perused the Database schema diagram (https://wiki.duraspace.org/display/DSDOC6x/Storage+Layer) but I can't see anywhere where this information appears to be held!? I've also tried searching the database "information_schema" for appropriately named columns - e.g.: select table_name from information_schema.columns where column_name like '%introductory_text%'; - but still no joy :( Can someone put me out of my misery and point me to where I can find the details relating to each Collection in the DB? My ultimate goal here is to extract a mapping from Collection names to uuids for use by an integration with our CRIS system (just in case it helps to know where I'm heading with this!) . . . Cheers, Mike Michael White Senior Developer Business Applications and Integrations T: (01786) 466877 E: michael.wh...@stir.ac.uk<mailto:michael.wh...@stir.ac.uk> A: G5, Airthrey Castle, University of Stirling, Stirling, FK9 4LA -- The University achieved an overall 5 stars in the QS World University Rankings 2016/17 The University of Stirling is a charity registered in Scotland, number SC 011159. -- 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
