<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Calibri" size="2"><span style="font-size:11pt;">
<div>I have successfully gotten full text indexing working on our RT 4.2.12 system, MySQL 5.5 back-end. At the present time, only the ticket history is being searched. This is my Sphinx query:</div>
<div> </div>
<div>sql_query = \</div>
<div> SELECT a.id, a.content FROM Attachments a \</div>
<div> JOIN Transactions txn ON a.TransactionId = txn.id AND txn.ObjectType = 'RT::Ticket' \</div>
<div> JOIN Tickets t ON txn.ObjectId = t.id \</div>
<div> WHERE a.ContentType = ('text/plain' or 'text/html') AND t.Status != 'deleted'</div>
<div> </div>
<div>Is there a way to modify this query to include some Ticket information (subject, requestor, etc.) in the search, or will users just have to use the Search Builder for more detailed searches?</div>
<div> </div>
<div>Thanks in advance!!</div>
<div> </div>
<div style="margin-top:5pt;margin-bottom:5pt;"><font face="Arial" size="2"><span style="font-size:10pt;">Stephen J. Cena<br>
Systems Administrator/Supervisor - MIS/IT Dept<br>
Quality Vision International<br>
850 Hudson Ave<br>
Rochester,NY 14620<br>
Phone: 585-544-0450 x300<br>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *<br>
Please report email problems to: <a href="mailto:postmaster@qvii.com"><font color="blue"><u>postmaster@qvii.com</u></font></a><font face="Times New Roman" size="3"><span style="font-size:12pt;"> </span></font></span></font></div>
<div style="margin-top:5pt;margin-bottom:5pt;"><font face="Arial" size="2"><span style="font-size:10pt;">QVII MIS/IT Dept - We do what we must because we can.<br>
"Thank you for helping us help you help us all."<br>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *</span></font></div>
<div> </div>
<div> </div>
</span></font>
</body>
</html>