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?
Fulltext Searching within the Customer Interface
Moderator: crythias
-
- Znuny expert
- Posts: 250
- Joined: 12 Oct 2010, 01:35
- Znuny Version: 3.0.9
- Company: LRS Health
Fulltext Searching within the Customer Interface
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

[Major Code Changes]
ArticleFreeTime1-3
Ability to search ArticleFreeText
-
- 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
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
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
-
- 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
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.
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

[Major Code Changes]
ArticleFreeTime1-3
Ability to search ArticleFreeText