category_tree::get_mapped_trees_from_object_list (public)

 category_tree::get_mapped_trees_from_object_list object_id_list \
    [ locale ]

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

Get the category trees mapped to a list of objects.

Parameters:

object_id_list - list of object to get the mapped category trees.
locale (optional) - language in which to get the name. [ad_conn locale] used by default.

Returns:

Tcl list of lists: tree_id tree_name subtree_category_id assign_single_p require_category_p widget

Author:

Jade Rubick <jader@bread.com>

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

Testcases:

category_tree_procs

Source code:

        set result [list]

        db_foreach get_mapped_trees_from_object_list [subst {
            select tree_id, subtree_category_id, assign_single_p,
                   require_category_p, widget
            from category_tree_map
            where object_id in ([ns_dbquotelist $object_id_list])
        }] {
            lappend result [list $tree_id [category_tree::get_name $tree_id $locale] $subtree_category_id $assign_single_p $require_category_p $widget]
        }

        return $result

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