#29 Search summary for Multipart Article Sections

[chris gilbert]

Our users don't like search results without any
summary text - I have included the parent article title,
as this will generally give the user some idea about the
context of the search result.

If this is included in a release, there needs to be an
upgrade script to put in summaries for existing articles.
I haven't included this as I am not sure about the lucene
setup. For our Oracle installation, I just ran the following
sql

update search_content x
set summary = (select 'A section of ' || a.title
from cms_pages a,
ct_mp_sections b
where a.item_id =
b.article_id
and b.section_id =
x.object_id)
where object_type
= 'com.arsdigita.cms.contenttypes.ArticleSection'

Chris.....

[chris gilbert]