<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"><font size="-1">I used<font size="-1"><font
size="-1"><font size="-1"> the default sphinx.conf
generated<font size="-1"><font size="-1"> </font>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></font></font></font></font></font></font></font></font>:<br>
<br>
<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"><font
size="-1">Q</font>uesti<font size="-1">on<font
size="-1"><font size="-1">:</font><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">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></font></font></font></font></font></font></font></font></font></font></font></font><font
size="-1"><font size="-1"><font size="-1" face="DejaVu Sans Mono">
</font><font face="DejaVu Sans Mono">Is it possible with </font><font
size="-1"><font face="DejaVu Sans Mono">the above configs of
sql_</font><font size="-1"><font face="DejaVu Sans Mono">q</font><font
size="-1"><font face="DejaVu Sans Mono">uery*</font><font
size="-1"><font face="DejaVu Sans Mono">?</font><font
size="-1"><font face="DejaVu Sans Mono"> If <br>
<font size="-1"> </font>not please let me know
what more should I</font><font size="-1"><font
size="-1"><font face="DejaVu Sans Mono"> need to
add<font size="-1">?</font><br>
</font><br>
<font size="-1" face="DejaVu Sans Mono">Thanks,</font></font></font></font></font></font></font></font></font></font>
</body>
</html>