category::get_mapped_categories_multirow (public)

 category::get_mapped_categories_multirow [ -locale locale ] \
    [ -multirow multirow ] object_id

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

Returns multirow with: tree_id, tree_name, category_id, category_name

Switches:

-locale (optional)

-multirow (optional, defaults to "mapped_categories")

Parameters:

object_id (required)

object of which we want to know the mapped categories.

Returns:

multirow with tree and category information

Author:

Peter Kreuzinger <peter.kreuzinger@wu-wien.ac.at>

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

Testcases:

category_object_mapping

Source code:

    if { $locale eq ""} {set locale [ad_conn locale]}
    db_multirow $multirow select {
        select co.tree_id, aot.title, c.category_id, ao.title
          from category_object_map_tree co,
               categories c,
               category_translations ct,
               acs_objects ao,
               acs_objects aot
         where co.object_id = :object_id
           and co.category_id = c.category_id
           and c.category_id = ao.object_id
           and c.category_id = ct.category_id
           and aot.object_id = co.tree_id
           and ct.locale = :locale
         order by aot.title, ao.title
    }

XQL Not present:

Generic

PostgreSQL XQL file:

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

Oracle XQL file:

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