<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>So I finally think I fixed the
issue. If anyone is interested it seemed that in the
ArticleCollection_Overlay.pm file there was a select statement that had 2 things
wrong with it. It was generating the JOIN with OR’s instead of AND’s
and it was only searching through the Content field of the ObjectCustomFieldValues
table and not searching through the Largecontent field as well.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I changed the JOIN criteria to
an AND and i added in the Largecontent field as well to the WHERE clause. This
seems to have fixed the problem for me at the moment. I have a patch file
available if anyone else is having this problem and would like to take a look
at the file and try it out.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Here is the patch I wrote:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>### Patch for getting Custom
field searches working in RTFM 2.2.0RC5<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>### File location is
/opt/rt3/local/lib/RT/FM/ArticleCollection_Overlay.pm<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>---
ArticleCollection_Overlay.pm 2007-06-07 13:33:19.000000000
-0400<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>+++
jp_ArticleCollection_Overlay.pm.bak 2007-06-07 13:32:32.000000000 -0400<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>@@ -254,7 +254,7 @@<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
$self->Limit( LEFTJOIN =>
$ObjectValuesAlias,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
FIELD =>
'CustomField',<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
VALUE =>
$args{'FIELD'},<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>-
ENTRYAGGREGATOR => 'OR');<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>+
ENTRYAGGREGATOR => 'AND');<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
# Could convert the above to a non-left join and also enable the thing below<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
# $self->SUPER::Limit(
ALIAS =>
$ObjectValuesAlias,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
#
FIELD =>
'CustomField',<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>@@ -323,6 +323,15 @@<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'> else {<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
$self->SUPER::Limit(<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
ALIAS =>
$ObjectValuesAlias,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>+
FIELD =>
'Largecontent',<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>+
OPERATOR => $args{'OPERATOR'},<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>+
VALUE => $value,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>+
QUOTEVALUE => $args{'QUOTEVALUE'},<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>+
ENTRYAGGREGATOR => $args{'ENTRYAGGREGATOR'},<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>+
SUBCLAUSE => $clause,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>+
);<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>+
$self->SUPER::Limit(<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>+
ALIAS =>
$ObjectValuesAlias,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
FIELD =>
'Content',<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
OPERATOR => $args{'OPERATOR'},<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
VALUE => $value,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Thanks to everyone that helped
me find this,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>-Jeff<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>Jeff
Platter<br>
<b>Sent:</b> Wednesday, June 06, 2007 6:05 PM<br>
<b>To:</b> rt-users@lists.bestpractical.com<br>
<b>Subject:</b> [FILTER] [rt-users] RTFM search through body text 2.2.0RC5<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hi,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I’ve newly installed RT 3.6.3 and RTFM 2.2.0RC5. I
created a custom field for the Article’s body. The field name is called
body and the type is a wikitext area. Then I created a new class and added the
body field to that class. I setup the permissions so that I have full access to
the class. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I went ahead and created a new article in the class. Then
when I go to the advanced search and try and search for a word that is in the
body field it doesn’t return any results. I did some searching on the
mailing list archive and have seen others with a similar problem but no answer
yet. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I have tried installing older versions of RTFM to see if
they have the same problems. I installed ver 2.1.40 and that had the same
problem. Then I went all the way back to the latest final release of RTFM ver
2.0.4. This one actually does work. The only issue is that it is soooo
old that it doesn’t really fit in well with 3.6.3 and there is a bunch of
functionality missing.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Please someone help me… <o:p></o:p></p>
<p class=MsoNormal>Thanks,<o:p></o:p></p>
<p class=MsoNormal>-Jeff<o:p></o:p></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br>
-- <br>
This message has been scanned for viruses and <br>
dangerous content by <a href="http://www.mailscanner.info/"></b><b>MailScanner</a>,
and is <br>
believed to be clean. <o:p></o:p></span></p>
</div>
</body>
<br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.
</html>