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>

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