category_tree::map (public)

 category_tree::map -tree_id tree_id -object_id object_id \
    [ -subtree_category_id subtree_category_id ] \
    [ -assign_single_p assign_single_p ] \
    [ -require_category_p require_category_p ] [ -widget widget ]

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

Map a category tree to a package (or other object).

Switches:

-tree_id (required)

-object_id (required)

-subtree_category_id (optional)

-assign_single_p (optional, defaults to "f")

-require_category_p (optional, defaults to "f")

-widget (optional)

Options:

-tree_id

category tree to be mapped.

-object_id

object to map the category tree to.

-subtree_category_id

category_id of the subtree to be mapped. If not provided, the whole category tree will be mapped.

-assign_single_p

shows if the user will be allowed to assign multiple categories to objects or only a single one in this subtree.

-require_category_p

shows if the user will have to assign at least one category to objects.

Author:

Timo Hentschel <timo@timohentschel.de>

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

Testcases:

category_tree_procs

Source code:

        db_dml map_tree {
            insert into category_tree_map
                   (tree_id,  subtree_category_id,  object_id,  assign_single_p,  require_category_p,  widget)
            select :tree_id, :subtree_category_id, :object_id, :assign_single_p, :require_category_p, :widget
            from dual
            where not exists (select 1 from category_tree_map
                               where object_id = :object_id
                                 and tree_id = :tree_id)
        }

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