[rt-users] Both 'subject' and 'body' of an email ticket searchable via RT's web interface?

Subin subin at opensourcesolutions.co.in
Mon Feb 4 18:36:34 EST 2013

Hello all,

I usedthe default sphinx.conf generatedwhere the 'sql_query' to fetch 
data for indexing:

/*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' AND t.Status != 'deleted'

sql_query_info = SELECT * FROM Attachments WHERE id=$id


I'd like to fulltext search for patterns/words both in the 'subject' and 
'body'of an email ticket
from the RT's web interface 'Search' box.Is it possible with the above 
configs of sql_query*?If
not please let me know what more should Ineed to add?

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

More information about the rt-users mailing list