Forum OpenACS Development: Search: only root forums messages are indexed

I'm testing the search package on my local site and noticed that only root messages content are indexed. The forums_message_search__itrg enqueue an insert if the new message is a root one, an update on the root message otherwise. Since when performing the update it's the ID of the root message which is passed to retrieve and index the content, the entry of the root message is updated each time a new message is added to the thread.

I've fixed this on my local site to index every message, not only the root ones. I've written also an upgrade script to update the triggers and to enqueue previous non-indexed messages.

I don't know if there's a good reason to index only root messages (I can't think of any), if there isn't, I'll commit to oacs-5-3 branch.

I had a closer look and I think the problem is in the search::datasource implementation. The combined content of all messages of the thread should be indexed but the query to retrieve it is not correct:

<fullquery name="callback::search::datasource::impl::forums_message.messages">
<querytext>
select subject, content, format
from forums_messages
where message_id=:message_id
-- lets just get the message instead of the whole thread
-- replace with a connect by
</querytext>
</fullquery>

Thanks Dave. I'll fix that and try again.