Hello!
After I switched my TicketIndexModule from RuntimeDB to StaticDB my searchresults for certain strings are acting weird. I've rebuilt the FullTextIndex and the TicketIndex.
Search string in questions is:
Country: NOR
When doing a full text search or searching using the filter "Body" only results that contain part of the string (everything after ':', in this case "<space>NOR") is present in the ticket subject are presented. Tickets where the string is included in the body of an article are omitted.
Is the ':' causing trouble? I tried escaping it without any difference to the results.
Is it being interpreted as regexp?
edit:
Ticket::SearchIndex::Attribute and Ticket::SearchIndex::Filters have default values.
edit2:
After searching around some earlier there where suggestions that you could add a setting to your config that would log SQL requests, I can't however find the file in question and one that applies to postgresql instead of mysql. If I could see what search query is generated it'd be easier for me to see where it goes wrong.
Search in body shows subject results
Moderator: crythias
Search in body shows subject results
Running:
OTRS 4.0.5
distro: debian 6.0.10
db: PostgreSQL 8.4.21
OTRS 4.0.5
distro: debian 6.0.10
db: PostgreSQL 8.4.21