content::get_content_value (public)

 content::get_content_value revision_id

Defined in packages/acs-content-repository/tcl/filter-procs.tcl

Parameters:

revision_id

Returns:

content element corresponding to the provided revision_id

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

Testcases:

No testcase defined.

Source code:

 
    db_transaction {
        db_exec_plsql gcv_get_revision_id {}

        # Query for values from a previous revision
        set content [db_string gcv_get_previous_content ""]

    }

    return $content

Generic XQL file:

packages/acs-content-repository/tcl/filter-procs.xql

PostgreSQL XQL file:

<fullquery name="content::get_content_value.gcv_get_revision_id">
    <querytext>

        select 1

	</querytext>
</fullquery>

<fullquery name="content::get_content_value.gcv_get_previous_content">
    <querytext>
      
    select 
      content
    from 
      cr_revisions
    where 
      revision_id = :revision_id
  
      </querytext>
</fullquery>

packages/acs-content-repository/tcl/filter-procs-postgresql.xql

Oracle XQL file:

<fullquery name="content::get_content_value.gcv_get_revision_id">
    <querytext>

	  begin
	    content_revision.to_temporary_clob(:revision_id);
	  end;

	</querytext>
</fullquery>

<fullquery name="content::get_content_value.gcv_get_previous_content">
    <querytext>

    select 
      content
    from 
      cr_content_text
    where 
      revision_id = :revision_id

	</querytext>
</fullquery>

packages/acs-content-repository/tcl/filter-procs-oracle.xql