Fulltext Searching within the Customer Interface

Moderator: crythias

Locked
MichaelR
Znuny expert
Posts: 250
Joined: 12 Oct 2010, 01:35
Znuny Version: 3.0.9
Company: LRS Health

Fulltext Searching within the Customer Interface

Post by MichaelR »

This has got me,

I cannot perform a text search on any of the fields listed below in the Customer Interface:
From, To, Cc, Subject, Text

If I create a ticket with the word 'test' everywhere in it, and search for that ticket with the 'test' keyword, it doesn't show. But if I just search for open tickets instead, it's right there!

Filling any of those fields will result in a blank search result. The only thing that will return a result is a wildcard (*).

I will continue investigating, just wondering if anyone else can replicate this problem?
OTRS: 3.0.9 & ITSM 3.0.4 - OS: Windows 7 - DB: MySQL - Heaps of random/useful hacks :)
[Major Code Changes]
ArticleFreeTime1-3
Ability to search ArticleFreeText
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Fulltext Searching within the Customer Interface

Post by crythias »

while this might not be what you want, *test* doesn't work either?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
MichaelR
Znuny expert
Posts: 250
Joined: 12 Oct 2010, 01:35
Znuny Version: 3.0.9
Company: LRS Health

Re: Fulltext Searching within the Customer Interface

Post by MichaelR »

I tried with the wildcards, it looks like in the code that it's adding the '*' anyway on each side of the text.

The variables are passed through to CustomerTicketSearch.pm or whatever it is, and from there it's calling TicketSearch in Ticket.pm in the Kernal/System folder.

I'll keep digging, I don't think this is a permission error either, as I'm checking with a test customer will all privileges and they have a heap of open/closed test tickets.
OTRS: 3.0.9 & ITSM 3.0.4 - OS: Windows 7 - DB: MySQL - Heaps of random/useful hacks :)
[Major Code Changes]
ArticleFreeTime1-3
Ability to search ArticleFreeText
Locked