[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
*/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,
-------------- 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