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>

Partial Call Graph (max 5 caller/called nodes):
%3 test_category_crud category_crud (test categories) category::get_children category::get_children test_category_crud->category::get_children test_category_get_procs category_get_procs (test categories) test_category_get_procs->category::get_children test_category_tree_procs category_tree_procs (test categories) test_category_tree_procs->category::get_children db_list db_list (public) category::get_children->db_list

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

[ hide source ] | [ make this the default ]
Show another procedure: