<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On Tuesday 05 February 2013 05:21 AM,
Thomas Sibley wrote:<br>
</div>
<blockquote cite="mid:5110496B.5000407@bestpractical.com"
type="cite">
<pre wrap="">On 02/04/2013 03:36 PM, Subin wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> 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 I need to add?
</pre>
</blockquote>
<pre wrap="">
Most of the time true full-text indexing isn't needed for the Subject
since it's a normally indexed string with a max length. I'd suggest
first approaching this by extending RT::Search::Googleish with an
overlay that instead of defaulting unknown and quoted words to Subject
searches, defaults them to Subject OR Content searches. This will do
what you mean, and should be fairly simple. I know we've done it for
support clients. RT::Search::Googleish was written to be extensible
with minimal effort.
Thomas
--
Help improve RT by taking our user survey: <a class="moz-txt-link-freetext" href="https://www.surveymonkey.com/s/N23JW9T">https://www.surveymonkey.com/s/N23JW9T</a>
</pre>
</blockquote>
<font size="-1"><font face="DejaVu Sans Mono">I just searched the
documentati<font size="-1">on on how to do this. I'm not able to
find<br>
<font size="-1">any other than a brie<font size="-1">f de<font
size="-1">scription about </font></font></font></font></font></font><small>RT::Search::Googleish
here:<br>
<br>
<a class="moz-txt-link-freetext" href="http://bestpractical.com/rt/docs/4.0/RT/Search/Googleish.html">http://bestpractical.com/rt/docs/4.0/RT/Search/Googleish.html</a><br>
<br>
Thanks,<br>
</small>
</body>
</html>