Thanks, Christian: I never considered using the search function. George Kozak Cornell University
On Wed, Jan 3, 2018 at 3:22 AM, Christian Scheible < [email protected]> wrote: > Hi George, > > I like using the DSpace search for tasks like this. > > To find all items that have a dc.title set use this search: *dc.title:* > *(Example > on demo.dspace.org: http://demo.dspace.org/xmlui/ > discover?scope=%2F&query=dc.title%3A*&submit=) > You can also combine queries like this: *dc.title:* AND -dc.type:* *This > will find all items which have a dc.title but no dc.type (Example: > http://demo.dspace.org/xmlui/discover?scope=%2F&query=dc. > title%3A*+AND+-dc.type%3A*&submit=) > > Just remember that you are going to find only public items with the DSpace > search. If you need to find private (like withdrawn) items as well using > the database as Paul suggested is the only option. > > Regards > Christian > > Am 03.01.2018 um 10:10 schrieb Paul Münch: > > Hi George, > > here an addition. Some metadata fields are critical because alls > DSpace-Objects have metadata, i.e. Communities and Collections, too. > Especially fields like dc.title are also used for Communities and > Collections metadata. > > Best regards, > Paul > > > -------- Weitergeleitete Nachricht -------- > Betreff: Re: [dspace-tech] Finding out if a metadata field is used > Datum: Wed, 3 Jan 2018 08:34:49 +0100 > Von: Paul Münch <[email protected]> > <[email protected]> > Organisation: Universitätsbibliothek Marburg > An: George Kozak <[email protected]> <[email protected]> > > Hi George, > > I don't know if there is a DSpace tool but every metadata to dspace-object > relation is hold in database. So a SQL query is all you need. > You only have to know the "metadata_field_id". This is stored in the > "metadatafieldregistry" table. Either you looking in the Admin UI for > metadata-registry or you use a SQL-Query like this: "SELECT > metadata_field_id FROM metadatafieldregistry WHERE element='title' AND > qualifier='alternative';" (= field_id 71). > With this ID you can query the "metadatavalue" table, e.g. "SELECT > COUNT(*) FROM metadatavalue WHERE metadata_field_id = 71;" > > Best regards, > Paul > > > > Am 02.01.2018 um 21:36 schrieb George Kozak: > > Hi... > We are using DSpace 5.5 (going to 6.2). A Metadata Librarian at my site > asked if I could find out how many times a certain DC metadata field was > being used in DSpace instance. Has anyone ever queried the system for that > particular information, and if so, could you share with me how to do that > :-) ? > Thanks! > > -- > *************************** > George Kozak > Digital Library Specialist > Cornell University Library - IT > 218 Olin Library > Cornell University > Ithaca, NY 14853 > 607-255-8924 <(607)%20255-8924> > [email protected] > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > > > -- > Philipps-Universität Marburg | UB > Digitale Dienste | Wilhelm-Röpke-Straße 6 > <https://maps.google.com/?q=Wilhelm-R%C3%B6pke-Stra%C3%9Fe+6&entry=gmail&source=g> > | 08A09 > Tel. 06421/28-24624 | > -- > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > -- *************************** George Kozak Digital Library Specialist Cornell University Library - IT 218 Olin Library Cornell University Ithaca, NY 14853 607-255-8924 [email protected] -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
