Incorrect search results being returned
Posted on 2003-03-14
If a dynamically built FTSearch query in the following format (all UK date formats, dd/mm/yyyy, server is UK dates as well):
([DateToday_HD] >= 01/02/2003 or [Created] >= 01/02/2003 or [Date_Submitted] >= 01/02/2003) and [Brand] = "Smirnoff*"
This returns some records, but not all that I would expect. I can't see any difference between the records being returned and those that are not from a data type and content POV.
An example record that is not being returned has the following values:
DateToday_HD: 03/02/2003 (date field)
Created: 03/02/2003 12:45:40 (date field)
Date_Submitted: blank (date field)
Brand: Smirnoff Citrus Twist (text field)
I have had the FTIndex rebuilt, in case there was a corruption, but still no luck.
Any pointers gratefully received.