Hi,
I am using Search API with a MySQL database.
I have my dates stored as a text in the format of 'yyyy-mm-dd' and it's indexed as a fulltext field.
When I do a search for start date '1950-03-09' it returns some content that contains dates like '1950-10-30' and '1950-09-13'.
http://nsf-biomuseums.eeb.lsa.umich.edu/drupal/?q=search-specimen&field_...
But if I do a search on '1959-11-14', it works fine.
http://nsf-biomuseums.eeb.lsa.umich.edu/drupal/?q=search-specimen&field_...
I'm thinking the hyphen followed by a 0 is causing it to behave weird.
Any ideas on how to debug or work around the issue?
Thanks!!
Comments
Comment #2
drunken monkeyWhy? Wouldn't "String" be much more appropriate here?
Comment #3
tremor CreditAttribution: tremor commentedI have product part number "x3c07f1-02" which behaves similarly, the search returns all occurrences of the single digit "2" even though i have 3 character partial matching set.
Comment #4
drunken monkeyFor this, turning off the "Tokenizer" processor (or tweaking its settings) might resolve this. (Unless you're using Solr – play around with the Solr configs in that case.)