Hi,

Did you tried „%2011%year%” it sometmies helps!

Greetings

ES

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of ??????? ??????
Sent: Tuesday, August 21, 2012 3:28 PM
To: otrs@otrs.org
Subject: [otrs] GenericAgent and Fulltext-search

Hello!

Sorry for bad English.

I have a trouble with GenericAgent and Fulltext-search in article. I need search some text, "2011 year", for example.

I entered *2011 year* in Ticket Filter, and see "0 Tickets affected!" as result of search. Of course, I have tickets with "2011 year" in text – search from TICKETS->Search shows my tickets.

MySQL logs contains this:

SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id  INNER JOIN article art ON st.id = art.ticket_id  WHERE 1=1 AND (((art.a_body LIKE '%2011' )  AND (art.a_body LIKE 'year%' ) )) LIMIT 60000

How can I use GenericAgent with normal text search?

OTRS version 3.1.7+dfsg1-2 from Debian-testing.