[Rt-devel] Bug in RTFM-2.2.0RC6

Joop JoopvandeWege at mococo.nl
Tue Aug 14 09:49:05 EDT 2007


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.
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


More information about the Rt-devel mailing list