[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