{"id":293,"date":"2011-10-24T13:44:37","date_gmt":"2011-10-24T17:44:37","guid":{"rendered":"http:\/\/blogs.law.harvard.edu\/djcp\/?p=293"},"modified":"2011-10-27T11:11:13","modified_gmt":"2011-10-27T15:11:13","slug":"fulltext-wildcard-searching-with-rubyrails-and-sunspot","status":"publish","type":"post","link":"https:\/\/archive.blogs.harvard.edu\/djcp\/2011\/10\/fulltext-wildcard-searching-with-rubyrails-and-sunspot\/","title":{"rendered":"fulltext wildcard searching with ruby\/rails and sunspot"},"content":{"rendered":"

I love Sunspot<\/a> for full-text searching in Rails apps, but it took me a while to figure out how to do left-bound wildcard searching in full-text indexed fields.<\/p>\n

So – if we’re searching for “collis” in a set of fulltext indexed fields, in the default solr config supplied by sunspot you have to search for the entire word. To get “colli” or “coll” to return records with “collis” in the fulltext index, you just need to modify the solr config (in $RAILS_ROOT\/solr\/conf\/schema.xml<\/strong>), changing:<\/p>\n

\r\n<fieldType name=\"text\" class=\"solr.TextField\" omitNorms=\"false\">\r\n  <analyzer>\r\n    <tokenizer class=\"solr.StandardTokenizerFactory\"\/>\r\n    <filter class=\"solr.StandardFilterFactory\"\/>\r\n    <filter class=\"solr.LowerCaseFilterFactory\"\/>\r\n  <\/analyzer>\r\n<\/fieldType>\r\n<\/pre>\n
to:<\/p>\n
\r\n<fieldType name=\"text\" class=\"solr.TextField\" omitNorms=\"false\">\r\n  <analyzer type=\"index\">\r\n    <tokenizer class=\"solr.WhitespaceTokenizerFactory\"\/>\r\n    <filter class=\"solr.LowerCaseFilterFactory\"\/>\r\n    <filter class=\"solr.EdgeNGramFilterFactory\" minGramSize=\"1\" maxGramSize=\"50\" side=\"front\"\/>\r\n  <\/analyzer>\r\n  <analyzer type=\"query\">\r\n    <tokenizer class=\"solr.WhitespaceTokenizerFactory\"\/>\r\n    <filter class=\"solr.LowerCaseFilterFactory\"\/>\r\n  <\/analyzer>\r\n<\/fieldType>\r\n<\/pre>\n
which essentially makes the full text tokenizer create left-bound n-grams<\/a> for indexed terms. This taught me:<\/p>\n
    \n
  1. Solr\/lucene\/sunspot rock, and<\/li>\n
  2. I have more to learn about solr config because the schema.xml looks like it exposes some very powerful search juju.<\/li>\n<\/ol>\n
    Thanks to Arndt Lehmann’s tip on this<\/a> page.<\/p>\n","protected":false},"excerpt":{"rendered":"
    I love Sunspot for full-text searching in Rails apps, but it took me a while to figure out how to do left-bound wildcard searching in full-text indexed fields. So – if we’re searching for “collis” in a set of fulltext … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1984,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[17313,4166,615,17314,17317],"class_list":["post-293","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-lucene","tag-rails","tag-ruby","tag-solr","tag-testtag"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/archive.blogs.harvard.edu\/djcp\/wp-json\/wp\/v2\/posts\/293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/archive.blogs.harvard.edu\/djcp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/archive.blogs.harvard.edu\/djcp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/djcp\/wp-json\/wp\/v2\/users\/1984"}],"replies":[{"embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/djcp\/wp-json\/wp\/v2\/comments?post=293"}],"version-history":[{"count":12,"href":"https:\/\/archive.blogs.harvard.edu\/djcp\/wp-json\/wp\/v2\/posts\/293\/revisions"}],"predecessor-version":[{"id":306,"href":"https:\/\/archive.blogs.harvard.edu\/djcp\/wp-json\/wp\/v2\/posts\/293\/revisions\/306"}],"wp:attachment":[{"href":"https:\/\/archive.blogs.harvard.edu\/djcp\/wp-json\/wp\/v2\/media?parent=293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/djcp\/wp-json\/wp\/v2\/categories?post=293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/djcp\/wp-json\/wp\/v2\/tags?post=293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}