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.