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>
- Partial Call Graph (max 5 caller/called nodes):
- 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