The root of your problem, I think, is fq=city:den+haag which parses into city:den +defaultfield:haag
Try parens, i.e. city:(den haag). Attaching &debugQuery=on is often a way to see thing like this quickly.... Also, if you haven't seen the analysis page from the admin page, it's really valuable for figuring out the effects of analyzers. You can probably do something like: <fieldType name="myField" class="solr.TextField" sortMissingLast="true" omitNorms="true"> <analyzer> <tokenizer class="solr.KeywordTokenizerFactory"/> <filter class="solr.LowerCaseFilterFactory"/> </analyzer> </fieldType> to get what you want. Best Erick On Fri, Dec 3, 2010 at 10:46 AM, PeterKerk <vettepa...@hotmail.com> wrote: > > > Users call this URL on my site: > /?search=1&city=den+haag > or even /?search=1&city=Den+Haag (casing of ctyname can be anything) > > > Under water I call Solr: > > http://localhost:8983/solr/db/select/?indent=on&facet=true&fq=city:den+haag&q=*:*&start=0&rows=25&fl=id,title,friendlyurl,city&facet.field=city > > > but this returns 0 results, even though I KNOW there are exactly 54 records > that have an exact match on "den haag" (in this case even with lower casing > in DB). > > citynames are stored with various casings in DB, so when searching with > solr, the search must ignore casing. > > > my schema.xml > > <fieldType name="string" class="solr.StrField" sortMissingLast="true" > omitNorms="true" /> > <field name="city" type="string" indexed="true" stored="true"/> > > > To check what was going on, I opened my analysis.jsp, > > for field <name> I provide: "city" > for Field value (Index) I provide: "den haag" > When I analyze this I get: > "den haag" > > So that seems correct to me. Why is it that no results are returned? > > My requirements summarized: > - I want to search independant of case on cityname: > when user searches on "DEn HaAG" he will get the records that have > value > "Den Haag", but also records that have "den haag" etc. > - citynames may consists of multiple words but only an exact match is > valid, > so when user searches for "den", he will not find "den haag" records. And > when searched on "den haag" it will only return match on that and not other > cities like "den bosch". > > How can I achieve this? > > I think I need a new fieldtype in my schema.xml, but am not sure which > tokenizers and analyzers I need, here's what I tried: > > <fieldType name="exactmatch" class="solr.TextField" > positionIncrementGap="100" > > <analyzer> > <tokenizer class="solr.WhitespaceTokenizerFactory"/> > <filter class="solr.SynonymFilterFactory" synonyms="synonyms.txt" > ignoreCase="true" expand="false"/> > <filter class="solr.StopFilterFactory" ignoreCase="true" > words="stopwords_dutch.txt" /> > <filter class="solr.ISOLatin1AccentFilterFactory"/> > <filter class="solr.LowerCaseFilterFactory"/> > </analyzer> > </fieldType> > > > Help is really appreciated! > -- > View this message in context: > http://lucene.472066.n3.nabble.com/finding-exact-case-insensitive-matches-on-single-and-multiword-values-tp2012207p2012207.html > Sent from the Solr - User mailing list archive at Nabble.com. >
