Hmm, trying to explain my problem a bit more verbosely, maybe someone can help
them.
For Intermedia site-wide search I need to define a procedure that indexes
certain content. I want the messages of one thread to be searchable under the
object_id/message_id of the very first message in the thread.
So if a user posts a new message, that new content needs to be put into the
side-wide index. If it's a new message that is relatively straight
forward. If it is an answer to a posting, I need to find out all related
messages. There's parent_id, message_id, and tree_sortkey in forums_messages
and all of them look like candidates in trying to pull together all related
messages. However I cannot yet really make sense of how they interrelate.
Especially confusing is that I cannot find any "connect by" in the forums
package.
The good news is: I don't need to put the message puzzle together properly or
in order, all I need is all the text that makes up a complete thread.
(Oh, current site-wide search still sits on bboard 😟)
