Thanks. (and pardon me for not finding this on the wiki in the first place).
There is a sample SQL statement on the page linked below which is used to find people (eperson). But if I want to find titles of items in our DSpace, I can’t see how to exclude filenames, collection and community names, etc. from the bibliographic data. The sample in the wiki looks like this: SELECT text_value FROM metadatavalue WHERE metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry mfr, metadataschemaregistry msr WHERE mfr.metadata_schema_id = msr.metadata_schema_id AND short_id = 'eperson' AND element = 'lastname' AND qualifier IS NULL ); If I alter it slightly to this: SELECT text_value FROM metadatavalue WHERE metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry mfr, metadataschemaregistry msr WHERE mfr.metadata_schema_id = msr.metadata_schema_id AND short_id = 'dcterms' AND element = 'title' AND qualifier IS NULL ); I still get filenames, formats and other information about resources that is not bibliographic information (see below where the first 4 lines are not what I want, but the remainder are) LICENSE license.txt ORIGINAL 39088017609827.pdf Review of: Alan Feduccia’s Riddle of the Feathered Dragons: what reptiles gave rise to birds? The imperfect art of reintroduction. Review of "Meant to be Wild: the Struggle to Save Endangered Species Through Captive Breeding" by J. DeBlieu and "Beyond Captive Breeding: Re-introducing Endangered Mammals to the Wild" edited by J. H. W. Gipps Testing Decision Rules for Categorizing Species’ Extinction Risk to Help Develop Quantitative Listing Criteria for the U.S. Endangered Species Act Persistence of different-sized populations: an empirical assessment of rapid extinctions in bighorn sheep "Mobbing" in Hawaiian monk seals: The value of simulation modeling in the absence of apparently crucial data Cyclic Drought, Dispersal, and the Conservation of the Snail Kite in Florida, Lessons in Critical Habitat etc . . . etc . . . Can you provide any guidance? -Alvin Hutchinson Smithsonian Libraries From: [email protected] [mailto:[email protected]] On Behalf Of helix84 Sent: Thursday, June 30, 2016 5:58 PM To: Hutchinson, Alvin <[email protected]> Cc: DSpace Community <[email protected]> Subject: Re: [dspace-community] Filenames in Metadatavalue Text_value You can also read the explanation of that change here: https://wiki.duraspace.org/display/DSPACE/Metadata+for+all+DSpace+objects Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- You received this message because you are subscribed to the Google Groups "DSpace Community" 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-community. For more options, visit https://groups.google.com/d/optout.
