Hi Alvin, you can add the resource_type_id of the resource you want to the query. The resource types can be found here: https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/core/Constants.java#L17
So 2 being the resource type for an item SELECT text_value FROM metadatavalue WHERE resource_type_id=2 AND ... [YourOtherClauses) Hope that helps Claudia Am 01.07.2016 um 17:43 schrieb Hutchinson, Alvin:
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
-- Claudia Juergen Eldorado Technische Universität Dortmund Universitätsbibliothek Vogelpothsweg 76 44227 Dortmund Tel.: +49 231-755 40 43 Fax: +49 231-755 40 32 [email protected] www.ub.tu-dortmund.de Wichtiger Hinweis: Die Information in dieser E-Mail ist vertraulich. Sie ist ausschließlich für den Adressaten bestimmt. Sollten Sie nicht der für diese E-Mail bestimmte Adressat sein, unterrichten Sie bitte den Absender und vernichten Sie diese Mail. Vielen Dank. Unbeschadet der Korrespondenz per E-Mail, sind unsere Erklärungen ausschließlich final rechtsverbindlich, wenn sie in herkömmlicher Schriftform (mit eigenhändiger Unterschrift) oder durch Übermittlung eines solchen Schriftstücks per Telefax erfolgen. Important note: The information included in this e-mail is confidential. It is solely intended for the recipient. If you are not the intended recipient of this e-mail please contact the sender and delete this message. Thank you. Without prejudice of e-mail correspondence, our statements are only legally binding when they are made in the conventional written form (with personal signature) or when such documents are sent by fax. -- 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.
