Thanks, Tim. Those are some very useful DB functions for making it much easier to query DSpace's very normalized and efficient table definitions.
I'll definitely build my custom queries around those helper functions. Stacy On Wednesday, November 22, 2017 at 10:11:52 AM UTC-6, Tim Donohue wrote: > > Hi Stacy, > > Just as a quick FYI, some "helper SQL functions" have been gathered on the > wiki at: > https://wiki.duraspace.org/display/DSPACE/Helper+SQL+functions+for+DSpace+6 > > These functions make querying the DSpace 6 database a bit easier (see > examples on that page). > > - Tim > > On Thu, Nov 16, 2017 at 2:03 PM Stacy Pennington <[email protected] > <javascript:>> wrote: > >> Does anyone out there have some useful PostgreSQL queries already written >> for DSpace 6.2? >> >> I've found several sets of PostgreSQL queries that were useful for >> earlier versions of DSpace, but most of them appear to be written between >> the versions 1.8 and 4.x, and the database changes from the past few years, >> particularly the UUID use, make many of them not work today. My attempts to >> repair them and make them work for 6.2 haven't gone well. >> >> What I'm actually looking for is a query that would provide a >> hierarchical list of communities, sub-communities, and collections in >> simple list, probably with just 2-space character indention at each >> successive sub-level, include the number of items at each level. Basically, >> think of something like what you get when you click Browse > Communities & >> Collections in the JSPUI interface but without the images and intro text of >> each community/collection and with the number of items for each level. >> >> (Basically, we need this because we are trying to flatten and >> uncomplicate our current DSpace topology, and we have over 500 collections, >> so getting an overview or monitoring our progress is really difficult.) >> >> Before I dive into this and try to create one of these SQL queries on my >> own, it seems like a good idea to see if anyone has already done it. >> >> Thanks. >> >> Stacy >> >> -- >> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/dspace-tech. >> For more options, visit https://groups.google.com/d/optout. >> > -- > > Tim Donohue > Technical Lead for DSpace & DSpaceDirect > DuraSpace.org | DSpace.org | DSpaceDirect.org > > -- 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.
