etp::get_subtopics (public)

 etp::get_subtopics

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

Author:
Luke Pond
Created:
2001-06-13 Creates a variable named "subtopics" in the caller's context. This is a multirow result set suitable for passing to an index template, containing all the structured data necessary to present a list of links to subtopics. The columns in the "subtopics" query are:
  • name
  • title
  • description

Partial Call Graph (max 5 caller/called nodes):
%3 ad_conn ad_conn (public) db_multirow db_multirow (public) etp::get_subtopics etp::get_subtopics etp::get_subtopics->ad_conn etp::get_subtopics->db_multirow

Testcases:
No testcase defined.
Source code:
        set package_id [ad_conn package_id]
        upvar subtopics subtopics
        db_multirow subtopics get_subtopics ""
Generic XQL file:
packages/edit-this-page/tcl/etp-procs.xql

PostgreSQL XQL file:
<fullquery name="etp::get_subtopics.get_subtopics">
    <querytext>
select child.name, child.node_id, child.object_id as package_id,
                   etp__get_title(f.folder_id,NULL) as title,
                   etp__get_description(f.folder_id,NULL) as description,
	           site_node__url(child.node_id) as url
  from site_nodes parent, site_nodes child, apm_packages p,
  cr_folders f
 where parent.object_id = :package_id
   and child.parent_id = parent.node_id
   and child.object_id = p.package_id
   and p.package_key = 'edit-this-page'
   and f.package_id=p.package_id
</querytext>
</fullquery>
packages/edit-this-page/tcl/etp-procs-postgresql.xql

Oracle XQL file:
<fullquery name="etp::get_subtopics.get_subtopics">
    <querytext>
select child.name, child.node_id, child.object_id as package_id,
                   etp.package_title(child.object_id) as title,
                   etp.package_description(child.object_id) as description
  from site_nodes parent, site_nodes child, apm_packages p
 where parent.object_id = :package_id
   and child.parent_id = parent.node_id
   and child.object_id = p.package_id
   and p.package_key = 'edit-this-page'
</querytext>
</fullquery>
packages/edit-this-page/tcl/etp-procs-oracle.xql

[ hide source ] | [ make this the default ]
Show another procedure: