Re: [dspace-tech] Search based on workflow criteria

[Alan Orth]

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  wrote:

> Hi Andrea!
>
> Let me put things straight: *it worked*, thank you very much!
>
> However, I had to comment out only the  tag and re-run
> index-discovery. The way comments were done before, the indexing wasn't
> working.
>
> 
> static-field="org.dspace.core.Constants.ITEM"/>
>
> **
>
> 
>
>
>
> 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?
>
> 
> static-field="org.dspace.core.Constants.ITEM"/>
>
>   dc.description.provenance
>
> 
>
> 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*
>  id="org.dspace.discovery.configuration.DiscoveryConfigurationService"
> class="org.dspace.discovery.configuration.DiscoveryConfigurationService">
> 
> 
> 
>  static-field="org.dspace.core.Constants.ITEM"/>
> 
> dc.description.provenance
> 
> 
> 
> 
> 
>
>
> 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 dspace-tech+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-tech@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>
-- 

Alan Orth
alan.o...@gmail.com
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 dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https:

Re: [dspace-tech] Search based on workflow criteria

[Tiago Delboni]

Hi Andrea!

Let me put things straight: *it worked*, thank you very much!

However, I had to comment out only the  tag and re-run 
index-discovery. The way comments were done before, the indexing wasn't 
working.


   
   
**
   



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?
>
> 
> static-field="org.dspace.core.Constants.ITEM"/>
>
>   dc.description.provenance
>
> 
>
> 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*
>> > id="org.dspace.discovery.configuration.DiscoveryConfigurationService" 
>> class="org.dspace.discovery.configuration.DiscoveryConfigurationService">
>> 
>> 
>> 
>> > static-field="org.dspace.core.Constants.ITEM"/>
>> 
>> dc.description.provenance
>> 
>> 
>> 
>> 
>> 
>>
>>
>> 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
>>
>>

-- 
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 dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Search based on workflow criteria

[Tiago Delboni]

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?


   
   
  dc.description.provenance
   


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*
>  id="org.dspace.discovery.configuration.DiscoveryConfigurationService" 
> class="org.dspace.discovery.configuration.DiscoveryConfigurationService">
> 
> 
> 
>  static-field="org.dspace.core.Constants.ITEM"/>
> 
> dc.description.provenance
> 
> 
> 
> 
> 
>
>
> 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
>
>

-- 
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 dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Search based on workflow criteria

[Andrea Schweer]

  
  
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

  
      
      
          
          
          dc.description.provenance
          
      
      
  
  

  


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
  




-- 
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 dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Search based on workflow criteria

[Tiago Delboni]

Hi Andrea!

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.

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?

We also have this settings regarding provenance:

*dspace.cfg*
metadata.hide.dc.description.provenance = true

*discovery.xml*






dc.description.provenance







Tiago

Em segunda-feira, 30 de maio de 2016 18:26:00 UTC-3, Andrea Schweer 
escreveu:
>
> Hi Tiago,
>
> On 11/05/16 22:50, Tiago Delboni wrote:
>
> I would like to perform searchs on DSpace 5.x based on workflow criteria 
> such as "submitted by" and "approved by".
>
>
> I see two options:
>
>- make dc.description.provenance searchable -- it may not be desirable 
>to expose all information in that field to the general public, but it's 
>certainly the easiest way
>- write a custom submission step and/or workflow processing action (if 
>you're using the customisable workflow; otherwise customise the 
>InstallItem#populateMetadata 
>
> 
>  
>method) that puts the submitter/approver information into a separate 
>metadata field in addition to dc.description.provenance, then make that 
>field searchable 
>
> cheers,
> Andrea
>
> -- 
> Dr Andrea Schweer
> Lead Software Developer, ITS Information Systems
> The University of Waikato, Hamilton, New Zealand
> +64-7-837 9120
>
>

-- 
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 dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Search based on workflow criteria

[Andrea Schweer]

  
  
Hi Tiago,

On 11/05/16 22:50, Tiago Delboni wrote:


  I would like to perform searchs on DSpace 5.x based
on workflow criteria such as "submitted by" and "approved by".
  


I see two options:

  make dc.description.provenance searchable -- it may not be
desirable to expose all information in that field to the general
public, but it's certainly the easiest way
  
  write a custom submission step and/or workflow processing
action (if you're using the customisable workflow; otherwise
customise the InstallItem#populateMetadata
method) that puts the submitter/approver information into a
separate metadata field in addition to
dc.description.provenance, then make that field searchable

cheers,
Andrea

-- 
Dr Andrea Schweer
Lead Software Developer, ITS Information Systems
The University of Waikato, Hamilton, New Zealand
+64-7-837 9120
  




-- 
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 dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.