category::get_mapped_categories (public)

 category::get_mapped_categories [ -tree_id tree_id ] object_id

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

Gets the list of categories mapped to an object. If tree_id is provided return only the categories mapped from the given tree.

Switches:

-tree_id (optional)

Parameters:

object_id (required)

object of which we want to know the mapped categories.

Returns:

tcl-list of category_ids

Author:

Timo Hentschel <timo@timohentschel.de>

Testcases:

category_object_mapping

Source code:

    return [db_list get_mapped_categories {
        select category_id from category_object_map
        where object_id = :object_id
        and (:tree_id is null or category_id in (select category_id
                                                 from categories
                                                 where tree_id = :tree_id))
    }]

XQL Not present:

Generic

PostgreSQL XQL file:

packages/categories/tcl/categories-procs-postgresql.xql

Oracle XQL file:

packages/categories/tcl/categories-procs-oracle.xql