Thanks, Claudia. That worked.
I will update the Wiki if I see a need but for those who are keeping score, the query would be: SELECT text_value FROM metadatavalue WHERE metadatavalue.resource_type_id=2 AND metadatavalue.metadata_field_id=64 Thanks again to all, -Alvin -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Claudia Jürgen Sent: Monday, July 04, 2016 6:00 AM To: [email protected] Subject: Re: [dspace-community] Filenames in Metadatavalue Text_value 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+obje > cts > > > 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. -- 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.
