Hello, I was just aiming to answer the same question, ie "how many items were submitted by an editor in a certain year?" Knowing that the editor's name is embedded in the dc.description.provenance field I whipped up the following query:
dspace=# select * from metadatavalue where resource_type_id=2 and metadata_field_id IN (select metadata_field_id from metadatafieldregistry where element = 'description' and qualifier = 'provenance') and text_value ~ '^Submitted.*orth.*2016-.*'; That returns all fields beginning with "Submitted" that have both "orth" and "2016-" in the text. I suppose there's the possibility that some of these fields belong to items that haven't been approved yet (or have been deleted), but it should otherwise be correct. So take it with a grain of salt! Cheers, On Fri, Jun 3, 2016 at 6:44 PM Tiago Delboni <[email protected]> wrote: > Hi Andrea! > > Let me put things straight: *it worked*, thank you very much! > > However, I had to comment out only the <value> tag and re-run > index-discovery. The way comments were done before, the indexing wasn't > working. > > <entry> > <key><util:constant > static-field="org.dspace.core.Constants.ITEM"/></key> > <list> > * <!-- Comment out the line bellow to index * > *dc.description.provenance --> <!--<value>dc.description.* > *provenance</value>-->* > </list> > </entry> > > > > Em quinta-feira, 2 de junho de 2016 13:40:46 UTC-3, Tiago Delboni escreveu: > > Hi Andrea, thanks for helping! > > I commented out the following lines in " > [dspace]/config/spring/api/discovery.xml" and then ran "dspace > index-discovery -b". It is still not working, ie, querying for "Submitted > by Valquiria Rosa" returns no item. > > Do I need to configure "dc.description.provenance" as a search filter to > make it searchable? > > <entry> > <key><util:constant > static-field="org.dspace.core.Constants.ITEM"/></key> > <list> > <value>dc.description.provenance</value> > </list> > </entry> > > Em quarta-feira, 1 de junho de 2016 22:38:30 UTC-3, Andrea Schweer > escreveu: > > Hi Tiago, > > On 02/06/16 04:51, Tiago Delboni wrote: > > I'm having a hard time understanding and configuring DSpace's search. I > have a lot of questions, please help me out. We're on DSpace 5.x using > default Solr/Discovery search. > > > In case you haven't found it, the appropriate documentation is at > https://wiki.duraspace.org/display/DSDOC5x/Discovery#Discovery-ModifyingtheDiscoveryUserInterface%28config/spring/api/discovery.xml%29 > > > When you say to "make dc.description.provenance searchable", it means to > create a "search.index.n" config? We already have this one: > > search.index.17 = descriptions:dc.description.* > > However, I can't search on "dc.description.provenance" using the > searchbox with queries like "Submitted by Valquiria Rosa" or "Approved > for entry into archive by Eliana Cunha". > > Is this configuration effective only for Legacy Lucene/DB search or > "search.index.n" also defines searchable metadata for Solr/Discovery? > > > The search.index settings are not used by Discovery. > > We also have this settings regarding provenance: > > *dspace.cfg* > metadata.hide.dc.description.provenance = true > > > I believe this setting now only controls the item page behaviour, though > it may also be used elsewhere (eg OAI). > > *discovery.xml* > <bean > id="org.dspace.discovery.configuration.DiscoveryConfigurationService" > class="org.dspace.discovery.configuration.DiscoveryConfigurationService"> > <property name="toIgnoreMetadataFields"> > <map> > <entry> > <key><util:constant > static-field="org.dspace.core.Constants.ITEM"/></key> > <list> > <value>dc.description.provenance</value> > </list> > </entry> > </map> > </property> > </bean> > > > This setting causes the search behaviour you're seeing -- it makes > dc.description.provenance not indexed in solr and hence not searchable via > Discovery. > > To make a custom field searchable, you don't have to do anything -- it > will be searchable by default. You only need to add a new search filter (as > described in the documentation linked above) if you want to be able to > search specifically in that field via the "advanced filters" functionality. > > cheers, > Andrea > > -- > Dr Andrea Schweer > Lead Software Developer, ITS Information Systems > The University of Waikato, Hamilton, New Zealand+64-7-837 9120 > <+64%207-837%209120> > > -- > 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. > -- Alan Orth [email protected] https://englishbulgaria.net https://alaninkenya.org https://mjanja.ch -- 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.
