forum::message::open (public)

 forum::message::open -message_id message_id

Defined in packages/forums/tcl/messages-procs.tcl

Reopen a thread.
This is not exactly a cheap operation if the thread is long.

Switches:

-message_id

(required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

forum_message_new

Source code:

    db_dml close_thread {
        update forums_messages set
           open_p = 't'
        where message_id in (
           with recursive message_hierarchy as (
              select message_id
                from forums_messages
               where message_id = :message_id

              union all

              select m.message_id
                from forums_messages m,
                     message_hierarchy h
               where m.parent_id = h.message_id
           )
           select message_id
             from message_hierarchy
        )
    }

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

packages/forums/tcl/messages-procs.xql