I have successfully gotten full text indexing working on our RT 4.2.12 system, MySQL 5.5 back-end. At the present time, only the ticket history is being searched. This is my Sphinx query:
SELECT a.id, a.content FROM Attachments a
JOIN Transactions txn ON a.TransactionId = txn.id AND txn.ObjectType = ‘RT::Ticket’
JOIN Tickets t ON txn.ObjectId = t.id
WHERE a.ContentType = (‘text/plain’ or ‘text/html’) AND t.Status != ‘deleted’
Is there a way to modify this query to include some Ticket information (subject, requestor, etc.) in the search, or will users just have to use the Search Builder for more detailed searches?
Thanks in advance!!
Stephen J. Cena
Systems Administrator/Supervisor - MIS/IT Dept
Quality Vision International
850 Hudson Ave
Phone: 585-544-0450 x300