====== Solr Notes ====== Below are some examples/notes relating to Solr that may be useful for Solr users. **\\ ** **Example Queries**

**Term Query Example:** [[http://kaboodle.clinecenter.illinois.edu:8983/solr/index/terms?terms.fl=content&terms.prefix=extort&terms.limit=100|http:%%//%%kaboodle.clinecenter.illinois.edu:8983/solr/index/terms?terms.fl=content&terms.prefix=extort&terms.limit=100]]\\ \\
**Term Query Example with regex: **[[http://kaboodle.clinecenter.illinois.edu:8983/solr/index/terms?terms.fl=content&terms.regex=.*extort&terms.limit=100|http:%%//%%kaboodle.clinecenter.illinois.edu:8983/solr/index/terms?terms.fl=content&terms.regex=.*extort&terms.limit=100]]\\ \\
**Add Term Frequency Count to Output:** [[http://kaboodle.clinecenter.illinois.edu:8983/solr/index/select?q=title:anti&rows=10&fl=aid,title,score,termfreq(|http:%%//%%kaboodle.clinecenter.illinois.edu:8983/solr/index/select?q=title:anti&rows=10&fl=aid,title,score,termfreq('content','anti'),termfreq('title','anti')&indent=true&sort=termfreq('content','anti')]] desc\\ \\
**Filter results based on Term Frequency: **[[http://kaboodle.clinecenter.illinois.edu:8983/solr/index/select?fl=aid|http:%%//%%kaboodle.clinecenter.illinois.edu:8983/solr/index/select?fl=aid]], title,publication_date,termfreq('content','coronavirus')&fq={!frange u=2}termfreq('content','coronavirus')&q=(content:coronavirus AND publication_date:[2018-01-01T00:00:00Z TO 2020-02-25T08:06:15Z])&sort=termfreq('content','coronavirus') desc\\ \\
**Query with 'Debug': **[[http://kaboodle.clinecenter.illinois.edu:8983/solr/index/select?debugQuery=on&fl=aid|http:%%//%%kaboodle.clinecenter.illinois.edu:8983/solr/index/select?debugQuery=on&fl=aid]] source_name publisher source_location&q=publisher:"The New York Times"\\ \\
**Query with the 'stats' component: **
- http://kaboodle.clinecenter.illinois.edu:8983/solr/index/select?fl=ingest_date&indent=on&q=source_name:Web%20AND%20publication_date:%5B2018-01-01T00:00:000Z%20TO%202020-06-23T00:00:000Z%5D&sort=ingest_date%20desc&wt=json&group=true&group.field=source_url&rows=0&stats=true&stats.field=content_length&stats.facet=source_url[[http://kaboodle.clinecenter.illinois.edu:8983/solr/index/select?fl=ingest_date&indent=on&q=source_name:Web%20AND%20publication_date:%5B2018-01-01T00:00:000Z%20TO%202020-06-23T00:00:000Z%5D&sort=ingest_date%20desc&wt=json&group=true&group.field=source_url&rows=0&stats=true&stats.field=content_length&stats.facet=source_url| ]]\\
- http://kaboodle.clinecenter.illinois.edu:8983/solr/index/select?q=status:empty&rows=0&stats=true&stats.field=content_length&stats.facet=source_url
- http://kaboodle.clinecenter.illinois.edu:8983/solr/index/select?q=status:empty&rows=0&stats=true&stats.field=content_length&stats.facet=source_name
- http://kaboodle.clinecenter.illinois.edu:8983/solr/index/select?q=status:empty&rows=0&stats=true&stats.field=content_length
- http://kaboodle.clinecenter.illinois.edu:8983/solr/index/select?q=*:*&rows=0&stats=true&stats.field=content_length&stats.field=status
  
  \\
**Query with 'group' component** (This will group specific fields by unique values and then produce a count):
- http://kaboodle.clinecenter.illinois.edu:8983/solr/index/select?fl=publishers&q=*%3A*&group=true&group.field=source_name

\\ **Notes:** - When generating queries, it is important to add the field name to all of the search terms you are using, otherwise, Solr will default to the content field for terms that have no field specification. - When running facet queries, make sure that you are faceting on is specified as a 'DocValues' within the Solr schema. Faceting on fields that are not 'DocValues' can potentially bring Solr down. \\