category::get_children (public)

 category::get_children -category_id category_id

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

Returns the category ids of the direct children of the given category

Switches:

-category_id (required)

category_id

Returns:

list of category ids of the children of the supplied category_id

Author:

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

Testcases:

category_crud, category_get_procs, category_tree_procs

Source code:

    return [db_list get_children_ids {
        select category_id
          from categories
         where parent_id = :category_id
           and deprecated_p = 'f'
      order by tree_id, left_ind
    }]

XQL Not present:

Generic

PostgreSQL XQL file:

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

Oracle XQL file:

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