[rt-users] Include Ticket information in full text index

[Cena, Stephen (ext. 300)]

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:

sql_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
Rochester,NY 14620
Phone: 585-544-0450 x300
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Please report email problems to: postmaster at qvii.com<mailto:postmaster at qvii.com>
QVII MIS/IT Dept - We do what we must because we can.
"Thank you for helping us help you help us all."
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20150904/ebfe73f2/attachment.htm>