acs_messaging_first_ancestor (public)

 acs_messaging_first_ancestor message_id

Defined in packages/acs-messaging/tcl/acs-messaging-procs.tcl

Takes the message_id of an acs_message and returns the message_id of the first ancestor message (i.e. the message that originated the thread).

Parameters:

message_id (required)

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

Testcases:

No testcase defined.

Source code:

    db_1row acs_message_first_ancestor {}

    return $ancestor_id

Generic XQL file:

packages/acs-messaging/tcl/acs-messaging-procs.xql

PostgreSQL XQL file:

<fullquery name="acs_messaging_first_ancestor.acs_message_first_ancestor">
    <querytext>
      select acs_message__first_ancestor(:message_id) as ancestor_id
    </querytext>
</fullquery>

packages/acs-messaging/tcl/acs-messaging-procs-postgresql.xql

Oracle XQL file:

<fullquery name="acs_messaging_first_ancestor.acs_message_first_ancestor">
    <querytext>
      select acs_message.first_ancestor(:message_id) as ancestor_id from dual
    </querytext>
</fullquery>

packages/acs-messaging/tcl/acs-messaging-procs-oracle.xql