[Rt-devel] Bug in RTFM-2.2.0RC6

[Kevin Falcone]

On Aug 14, 2007, at 9:49 AM, Joop wrote:

> I just found out that when searching for article content only the  
> content column is added to the search but not the largecontent  
> column of ObjectCustomFieldValues.

I applied a patch that I think fixes this to svn.
It should be revision 8017 in bps-public

-kevin

> SELECT COUNT (DISTINCT main.ID)
>   FROM fm_articles main LEFT JOIN objectcustomfieldvalues  
> objectcustomfieldvalues_2
>        ON (objectcustomfieldvalues_2.disabled = '0')
>      AND (objectcustomfieldvalues_2.objectid = main.ID)
>        JOIN fm_objecttopics fm_objecttopics_1 ON  
> (fm_objecttopics_1.objectid = main.ID)
>  WHERE (fm_objecttopics_1.objecttype = 'RT::FM::Article')
>    AND (LOWER (main.CLASS) = '1')
>    AND (fm_objecttopics_1.topic = '194')
>    AND (   objectcustomfieldvalues_2.content LIKE '192.168.'
>         OR LOWER (main.NAME) LIKE '192.168.'
>         OR LOWER (main.summary) LIKE '192.168.'
>        )
>
> Does anyone know where to start looking for adding this?
> I thought I had added this sometime ago but I can't find it back.
>
> Joop
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/ 
> rt-devel
>