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
*/Question:
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?
Thanks,
