<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font size="-1"><font face="DejaVu Sans Mono">Hello <font size="-1">all,<br>
<br>
<font size="-1">I<font size="-1"> setup RT v<font size="-1">4
with <font size="-1">fulltext with indexing.<font
size="-1"> I used the default sphinx.conf generated<br>
<font size="-1">where <font size="-1">t<font
size="-1">he 'sql_q<font size="-1">uery' to
fetch <font size="-1">data for indexing</font></font></font></font></font>
is like:<br>
<br>
</font></font></font></font></font></font></font></font><font
size="-1"><font face="DejaVu Sans Mono"><font size="-1"><font
size="-1"><font size="-1"><font size="-1"><font size="-1"><i><b><font
size="-1">sql_query = \ SELECT a.id, a.content
FROM Attachments a \ <br>
<font size="-1"> </font>JOIN
Transactions txn ON a.TransactionId = txn.id AND
txn.ObjectType = 'RT::Ticket' \<br>
<font size="-1"> </font>JOIN Tickets
t ON txn.ObjectId = t.id \ WHERE a.ContentType =
'text/plain' AND t.Status != 'deleted' <br>
<br>
sql_query_info = SELECT * FROM Attachments WHERE
id=$id<br>
<br>
</font></b></i><font size="-1"><font size="-1">My
questi<font size="-1">on<font size="-1"> is:<br>
<br>
<font size="-1"><font size="-1"> </font> I'd
like to fulltext</font> search for patter<font
size="-1">ns<font size="-1">/words both in
the 'subject'</font></font> and '<font
size="-1"><font size="-1"></font>body'<font
size="-1"> of an email ticke<font
size="-1">t<br>
</font><font size="-1"> <font size="-1">from
the RT<font size="-1">'s web interface
<font size="-1">'Search<font
size="-1">' box.</font></font></font></font></font><font
size="-1"><font size="-1"><font
size="-1"> </font>Is it possible
with <font size="-1">the above
configs of sql_<font size="-1">q<font
size="-1">uery*<font size="-1">?<font
size="-1"> If <br>
<font size="-1"> </font>not
please let me know what more
should I<font size="-1"><font
size="-1"> need to add<font
size="-1">?</font><br>
<br>
<font size="-1">Thanks,</font></font></font></font><br>
</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>
</body>
</html>