
21 Aug
2012
21 Aug
'12
1:28 p.m.
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.