Fyi, DSpace 6 will have a mechanism to send this type of query in through the REST api.
https://demo.dspace.org/rest/static/reports/query.html?query_field[]=dc.contributor.author&query_op[]=exists&query_val[]=&collSel[]=7740c113-f0c1-4b76-bdec-32fcc9e23f01&limit=100&offset=0&expand=parentCollection%2Cmetadata&filters=none&show_fields[]=dc.contributor.author (You will need to accept the security warning at demo.dspace.org in order to view the query form and results). See https://wiki.duraspace.org/display/DSDOC6x/REST+Based+Quality+Control+Reports Terry On Thu, Sep 29, 2016 at 8:25 AM, Luiz dos Santos <luiz...@gmail.com> wrote: > Thanks Hardy and Helix84, that page is so nice! > > Luiz Claudio Santos > http://luizclaudiosantos.me/ > > On Thu, Sep 29, 2016 at 11:21 AM, Hardy Pottinger < > hardy.pottin...@gmail.com> wrote: > >> Hi, because not so many people know about this handy resource, I'll just >> jump in to say this page by Helix84 is fantastically useful for answering >> these sorts of SQL questions; >> >> https://wiki.duraspace.org/display/DSPACE/Helper+SQL+functions+for+DSpace >> >> Even if you don't define the functions, the SQL contained on this page is >> useful. >> >> --Hardy >> >> On Thu, Sep 29, 2016 at 8:12 AM, Alan Orth <alan.o...@gmail.com> wrote: >> >>> Hi, >>> >>> I want to generate a list of authors in a certain community and its >>> collections. My goal is to do some batch cleanups of the names. >>> Normally I just select all the distinct text_value fields for the >>> metadata field I'm interested in, like here for 3 >>> (dc.contributor.author): >>> >>> dspace=# select distinct text_value from metadatavalue where >>> resource_type_id=2 and metadata_field_id=3; >>> >>> But I don't understand DSpace's database schema well enough to limit >>> that to a certain community and its collections. >>> >>> Can anyone help? This is DSpace 5 + PostgreSQL. >>> >>> -- >>> Alan Orth >>> alan.o...@gmail.com >>> https://englishbulgaria.net >>> https://alaninkenya.org >>> https://mjanja.ch >>> "In heaven all the interesting people are missing." ―Friedrich Nietzsche >>> GPG public key ID: 0x8cb0d0acb5cd81ec209c6cdfbd1a0e09c2f836c0 >>> >>> -- >>> 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. >>> >> >> -- >> 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. >> > > -- > 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. > -- 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 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.
