category_tree::usage (public)

 category_tree::usage tree_id

Defined in packages/categories/tcl/category-trees-procs.tcl

Gets all package instances using a category tree.

Parameters:
tree_id (required)
category tree to get the using packages for.
Returns:
Tcl list of lists: package_pretty_plural object_id object_name package_id instance_name read_p
Author:
Timo Hentschel <timo@timohentschel.de>

Partial Call Graph (max 5 caller/called nodes):
%3 test_category_tree_procs category_tree_procs (test categories) category_tree::usage category_tree::usage test_category_tree_procs->category_tree::usage ad_conn ad_conn (public) category_tree::usage->ad_conn db_list_of_lists db_list_of_lists (public) category_tree::usage->db_list_of_lists packages/categories/www/cadmin/tree-delete-2.tcl packages/categories/ www/cadmin/tree-delete-2.tcl packages/categories/www/cadmin/tree-delete-2.tcl->category_tree::usage packages/categories/www/cadmin/tree-delete.tcl packages/categories/ www/cadmin/tree-delete.tcl packages/categories/www/cadmin/tree-delete.tcl->category_tree::usage packages/categories/www/cadmin/tree-usage.tcl packages/categories/ www/cadmin/tree-usage.tcl packages/categories/www/cadmin/tree-usage.tcl->category_tree::usage

Testcases:
category_tree_procs
Source code:
        set user_id [ad_conn user_id]

        return [db_list_of_lists category_tree_usage {
        select t.pretty_plural, n.object_id, n.title, p.package_id,
               p.instance_name,
               acs_permission.permission_p(n.object_id, :user_id, 'read') as read_p
        from category_tree_map m, acs_objects n,
             apm_packages p, apm_package_types t
        where m.tree_id = :tree_id
        and n.object_id = m.object_id
        and p.package_id = n.package_id
        and t.package_key = p.package_key
        }]
XQL Not present:
Generic
PostgreSQL XQL file:
packages/categories/tcl/category-trees-procs-postgresql.xql

Oracle XQL file:
packages/categories/tcl/category-trees-procs-oracle.xql

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