etp::revision_url (public)

 etp::revision_url object_id

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

returns the url of an etp page revision

Parameters:

object_id (required)

Author:

Dave Bauer

Testcases:

No testcase defined.

Source code:

    db_1row revision_url {}
  
    set package_url [db_string package_url {} -default "/"]
    
    return [string trimright "[ad_url]${package_url}${url}" "index"]

XQL Not present:

Oracle

Generic XQL file:

<fullquery name="etp::revision_url.revision_url">
    <querytext>
        select name as url, parent_id as package_id
        from cr_items 
	where live_revision = :object_id
	</querytext>
</fullquery>

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

PostgreSQL XQL file:

<fullquery name="etp::revision_url.package_url">
    <querytext>
select site_node__url(node_id) as package_url from site_nodes where object_id = (select package_id from cr_folders where folder_id= (select parent_id from cr_items where latest_revision = :object_id))
    </querytext>
</fullquery>

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