etp::get_live_revision_id (public)

 etp::get_live_revision_id package_id name

Defined in packages/edit-this-page/tcl/etp-procs.tcl

Parameters:

package_id
name

Author:

Luke Pond

Created:

2001-06-10 Returns the published ("live") revision id for the given content item.

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

Testcases:

No testcase defined.

Source code:

    db_1row get_live_revision_id ""
    return $revision_id

Generic XQL file:

packages/edit-this-page/tcl/etp-procs.xql

PostgreSQL XQL file:

<fullquery name="etp::get_live_revision_id.get_live_revision_id">
    <querytext>
	select live_revision as revision_id
          from cr_items i
         where i.parent_id = etp__get_folder_id(:package_id)
           and i.name = :name
</querytext>
</fullquery>

packages/edit-this-page/tcl/etp-procs-postgresql.xql

Oracle XQL file:

<fullquery name="etp::get_live_revision_id.get_live_revision_id">
    <querytext>
	select live_revision as revision_id
          from cr_items i
         where i.parent_id = etp.get_folder_id(:package_id)
           and i.name = :name
</querytext>
</fullquery>

packages/edit-this-page/tcl/etp-procs-oracle.xql