etp::get_latest_revision_id (public)

 etp::get_latest_revision_id package_id name

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

Parameters:

package_id (required)

name (required)

Author:

Luke Pond

Created:

2001-06-10 Returns the latest revision id for the given content item.

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

Testcases:

No testcase defined.

Source code:

        db_1row get_latest_revision_id ""
        return $revision_id

Generic XQL file:

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

PostgreSQL XQL file:

<fullquery name="etp::get_latest_revision_id.get_latest_revision_id">
    <querytext>
	select max(revision_id) as revision_id
          from cr_revisions r, cr_items i
         where i.parent_id = etp__get_folder_id(:package_id)
           and i.name = :name
           and i.item_id = r.item_id
</querytext>
</fullquery>

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

Oracle XQL file:

<fullquery name="etp::get_latest_revision_id.get_latest_revision_id">
    <querytext>
	select max(revision_id) as revision_id
          from cr_revisions r, cr_items i
         where i.parent_id = etp.get_folder_id(:package_id)
           and i.name = :name
           and i.item_id = r.item_id
</querytext>
</fullquery>

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